Home » Power BI » Apply all filters feature in Power BI

Apply all filters feature in Power BI

Apply all filters feature Power BI

Power BI November 2020 updates – Power BI has released Apply all filters feature. This feature helps you to optimize the filter pane for query reduction by applying all filter changes at once.

It is useful if you want to defer when to apply filter changes, so that you only have to wait once after you are ready to apply any filter changes to the report or visuals.

This feature will be off by default, and report authors can turn it on or off at the report level.



Prerequisite

Download Power Desktop latest version – https://powerbi.microsoft.com/en-us/downloads/

Sample Dataset download from here- Global Super Store Dataset

Add some visual on report page for example & Drag some fields under Filters Pane-

Filter Pane

Filter Pane

Follow these steps in order to enable Apply all button under Filter Pane-

Step-1: Click on File Tab > Option & Settings > Options.




Step-2: Current File >Click on Query reduction > select “Add a single Apply button to..” then click on OK.

Apply all filters

Apply all filters

Step-3: You can see the Apply button under Filters Pane after all fields. Now you can apply many filter selections at once.




Also, this feature will be useful for any report users who doesn’t want to wait for the report to update each time a single filter variable is applied.

Apply all filter feature example in Power BI

Apply all filter feature example in Power BI

How to customize Apply button-

Click on View Tab > Expend the Themes section > Choose customize the current theme > Filter Pane

Customize Filter pane Power BI

Customize Filter pane Power BI

See the customize filter pane output –




Customize filter pane result

Customize filter pane result

Refer other Power BI topics: Power BI tutorials

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.



Leave a Reply