Use the Apply All Slicers button

Overview

When a user filters a report using multiple slicers, Power BI sends a query to the data source for each interaction. A recommended best practice is to use the Apply All Slicers button whenever possible. This allows users to first select the required filter values from the slicers, then click Apply All Slicers to send the queries as a single request.

To apply this configuration in Power BI, perform the following steps:

1. In the Power BI toolbar, navigate to the Optimize tab, and locate the Apply All Slicers button to add this to a report.

   Open

   

    

   Power BI will add the Apply All Slicers button to your report.

   Open

   

    

2. After adding the button, whenever you interact with the slicers in the report, your selections will not be applied immediately. Instead, the slicers will display the message “Not yet applied.” This message indicates that the selected filters will only be applied after you click the Apply All Slicers button. Once the button is clicked, the selected filters are applied to the visuals, and the query is sent to the data source with the selected filters.

   Open