Apply all Slicer & Clear all slicer button in the Power BI
Consider a Power BI report which is having multi select slicers. When a user selects a value, it runs a query & renders the visual. Each time a value is selected this process repeats -- increasing the number of queries. This has an impact on user experience as well as performance when there are a greater number of values to be selected.
We can now achieve it using these new "Apply All Slicers" & "Clear All Slicers" buttons. These buttons have the capability to keep a track of the slicer selections & apply / cancel them together when a user clicks.
For example, suppose we have 6 slicers in a report, with the addition of 'Apply all slicers' Power BI executes the filtering of values from these 6 slicers together as a single query.
1. Create an Apply all slicers button In Power BI Desktop, on the Insert ribbon, select Buttons to reveal a drop-down menu, then select the Apply all slicers button.
To add the Apply all slicers button:
Step 1: Go the Insert menu and then click on Buttons.
Step 2: Select the “Apply all slicers” button from the given options.
The button is added to the page, and it is disabled state.
When we select the slicers, it becomes active, when we click on the Apply all slicers button. All filters are applied and again its state is changed to disabled.
We can change the text of the button from the “Format your visual” option.
Note: We can add multiple Apply all slicers button on the page of the report.
2. Add a Clear all slicers button A Clear all slicers button allows us to quickly and efficiently clear all slicer selections at once on the report page. This button is also a query reduction feature. Clearing the slicers one by one with the slicer’s Clear selections means for a five-slicer report, the first four times we clear the slicers, the visuals update before we are done. We have created four times six visual queries, or 24 unnecessary visual queries. With the Clear all slicers button, all the slicers are cleared, and then the other visuals update.
To add the Clear all slicers button:
Step 1: Go the Insert menu and then click on Buttons.
Step 2: Select the “Clear all slicers” button from the given options.
Step 3: After clicking on the slicers, we can see in the slicers it is showing (Not yet applied). When we click on “Apply all slicers” the slicer filters are applied. Or we have the option to clear the filters from the slicer.
We can see the effect after clicking on Clear all slicers.
