Managing Slicer Filters In Power BI
If you are working with Power BI, you probably already know how powerful Slicer filters are. The ability to add a Slicer and have it automatically filter everything on the report can be great! But, what about instances where you do not want the Slicer to filter all your tiles? Instead, you want the Slicer to filter only some of your tiles. How can you control your Slicers? Fortunately, as you will learn in this tip, managing Slicer filters in Power BI is exceptionally easy.
Limiting A Slicer's Reach
Consider the Power BI report shown in Figure 1. In this report, the “State” Slicer in the lower, right corner filters all six tiles by default. However, what if we wanted the Slicer to affect only the four tiles at the top of the report? What could we do to limit the Slicer’s reach?
The answer is simple. Once you add a Slicer, click on the Slicer to select it. Next, click the Format tab on the Ribbon. Then, click Edit Interactions, and upon doing so, you will see that each tile on the report will have two icons appear in the upper, right corner. For each of the tiles you do not want to filter with the Slicer, click the icon on the right side labeled None. Doing so will disconnect the Slicer from that tile. Once you complete this process, click Edit Interactions again to apply your changes.
Summary
Slicers are great tools for filtering your Power BI-based reports and dashboards quickly, easily, and intuitively. However, you may not want your Slicer to affect all the tiles on a page. In these cases, as you have just learned, you can easily disconnect a Slicer from a tile using Power BI’s Edit Interactions feature.
Interested in Power BI? Consider K2’s Business Intelligence, Featuring Microsoft’s Power BI Tools as the training “kick-starter” you need to begin mastering Power BI.
If you want to give Power BI a try and have not yet downloaded the free Power BI Desktop application, visit https://www.powerbi.com. The application is free to all users.
