top of page

Power BI Apply All Slicers, Clear All Slicers, and Optimization Presets

  • Writer: admin
    admin
  • 23 hours ago
  • 5 min read

Power BI's Apply All Slicers and Clear All Slicers buttons let you control when slicer selections trigger visual queries, directly reducing unnecessary load on your data source. Instead of each slicer change firing a separate refresh, all selections are batched and processed in a single update when you click the button. If you are new to the platform, the article what is Power BI covers the foundations before diving into these features.


Pair those buttons with query reduction settings from the Optimization Presets options, and you have a complete toolkit for building faster, more responsive Power BI reports. This guide walks through each feature, how to set them up, and when to use them together.



Apply All Slicers Button

The Apply All Slicers button defers slicer selections until the user explicitly clicks it, triggering a single visual refresh instead of one per slicer change. On a page with five slicers and six visuals, changing all five slicers without this button generates 30 visual queries before the user is done. With the button, those same actions generate just 6 — an 80% reduction in query volume.



This is especially useful when your report connects to a slow data source or DirectQuery model where each visual query hits the database directly. Instead of the database receiving 30 requests mid-interaction, it receives 6 at the point when the user is ready. You can explore other ways to make your reports more interactive in Making Page and Bookmark Navigation in Power BI.


How to add the Apply All Slicers button

  1. Open your report in Power BI Desktop.

  2. Go to the Insert ribbon.

  3. Select Buttons > Apply all slicers.

  4. Place the button on your canvas.


Once a slicer selection is pending, a small indicator appears on the slicer header. Clicking the button applies all pending selections at once and triggers a single visual refresh. Until you click it, the other visuals on the page remain unchanged regardless of how many slicer selections you make.


Limitations

  • Affects all slicers on the page — you cannot scope it to specific slicers only.

  • Does not apply to filters triggered by clicking on a visual (cross-filtering).

  • Does not work with slicers configured as single select.


For reports that use more advanced slicer configurations, see Dynamic Slicer Using Field Parameter and Power BI Input Slicer.


Clear all slicers button

The Clear All Slicers button resets every slicer on the page in a single click. Without it, clearing five slicers one by one triggers a visual refresh after each of the first four, generating up to 24 unnecessary queries before the final state is reached. The button batches all resets and runs one update after everything is cleared.



How to add the Clear All Slicers button

There are two ways to add this button. The first is the same path as Apply All Slicers:

  1. Go to Insert > Buttons > Clear all slicers.

  2. Place the button on your canvas.


Alternatively, configure any existing button to perform this action:

  1. Select the button on your canvas.

  2. In the Format pane, go to Button > Action.

  3. Change the Type to Clear all slicers.


Clicking the button clears all active slicer selections and updates the visuals accordingly.


Limitations

  • Works only on the current report page.

  • Does not clear filters applied by visual cross-filtering.

  • Does not affect single-select slicers.


Another approach to managing focused visual scope is the Zoom Slider for More Focused Visuals in Power BI, which complements slicer controls on dense report pages.


Optimization presets

Power BI's query reduction options give you predefined controls for reducing the number of queries your report sends to the data source on user interaction. These settings are accessible via File > Options and settings > Options, then under Current File > Query reduction.



The dialog gives you three areas to configure:

  1. Reduce number of queries sent by: Enabling this disables cross-highlighting and cross-filtering by default, preventing visuals from automatically filtering each other when a user clicks on a data point.

  2. Slicers: Microsoft recommends using the Apply All Slicers button rather than adding individual Apply buttons to each slicer. Adding individual Apply buttons per slicer is listed as "not recommended" because it creates more UI friction without the performance consistency of a single page-level button.

  3. Filters:

    • Instantly apply basic filter changes: every filter interaction immediately queries the data source.

    • Add Apply buttons to all basic filters: users must confirm each filter change individually before the visual updates.

    • Add a single Apply button to the filter pane: all filter changes are batched and applied at once — the same principle as Apply All Slicers, applied to the filter pane.


For DirectQuery connections or large datasets, selecting the third filter option and enabling the cross-highlighting/filtering disable will noticeably reduce the number of queries hitting your source.


When to Use All Three Together

These three features address the same root problem from different angles. On a DirectQuery report with multiple filters, the right setup is to:

  • Set query reduction to disable cross-highlighting and cross-filtering globally.

  • Add an Apply All Slicers button so users control when their filter selections execute.

  • Add a Clear All Slicers button so resetting filters does not generate cascading queries.


Together, they shift report interactivity from automatic to intentional — which reduces query volume and produces noticeably faster report load times for end users.


Optimize Your Power BI Reports with BI Solusi

Configuring slicers and query reduction settings correctly is one part of building a Power BI report that performs well in production. Getting the full picture — data model design, gateway configuration, workspace governance, and user adoption — is where implementation experience makes the difference.


BI Solusi is an official Microsoft Partner specializing in Business Intelligence, Data Analytics, and AI services. Recognized by Clutch as a Top BI & Big Data Company in Indonesia in 2022 and 2023, BI Solusi helps organizations plan, build, and optimize their Power BI environments — from initial data model design to enterprise-scale dashboards.


Whether you are starting your first Power BI deployment or improving reports that are already live, our team works with you to deliver solutions that are fast, scalable, and built to your actual data needs. Read our guide on how to choose a Power BI implementation partner or explore our approach to successful Business Intelligence implementation to learn more before reaching out.


BI Solusi is your trusted partner for data-driven success in Indonesia, serving companies in the Southeast Asia region and beyond. We specialize in implementing cutting-edge Data Analytics, Business Intelligence platform, and Big Data solution, complemented by expert Data Science services. 

 

We offer flexible nearshore and offshore BI implementation models to meet your specific needs and deliver the highest-quality results. 

 

Our BI Consulting expertise encompasses Data Integration services (ETL), Data Warehousing, and the utilization of Data Visualization tools such as Microsoft Power BI, Qlik Sense, and Tableau for Reports and Dashboards implementation.

 

Let us help you unlock the full potential of your data and achieve your business goals.

Comments

bottom of page