How to Clear Slicer Selection in Power BI

Power BI slicers are fantastic for making reports interactive, but requiring users to manually unclick every single choice to reset the view can be clunky. A messy report with countless active filters can frustrate users and hide important insights under layers of selections. This guide will walk you through several methods to add a "Clear All Selections" or "Reset Filters" button to your dashboard, dramatically improving the user experience.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why a 'Clear Selections' Button is a Game Changer for UX

Imagine a sales manager exploring a new report. They filter by "West Region," then by a specific salesperson, "Sarah," then by "Q4," and finally by "Widgets." Now, they want to start fresh and see the nationwide Q4 performance. How do they do that?

Without a dedicated reset button, their options are:

• Hold down Ctrl and meticulously click every selection again to deselect them.
• Hunt for the tiny "eraser" icon on each slicer, which isn't always intuitive for new users.

This friction gets in the way of smooth data exploration. A large, clearly labeled "Reset Filters" button solves this problem instantly. It makes your report feel more like a professional application and less like a complex spreadsheet, encouraging users to play with the data without worrying about getting lost in their own filters. It’s a small touch that signals a thoughtful, user-centric design.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 1: The Modern & Easy Way with the 'Reset Filters' Action

If you're using a modern version of Power BI Desktop (specifically, the May 2022 update or later), Microsoft has made this incredibly easy. The "Reset filters" action is the quickest and most straightforward way to add this functionality. The best part? No code or complex logic is needed.

Here’s how to set it up step-by-step:

Step 1: Insert a Button First, you need something for the user to click. Go to the Insert tab on the Power BI ribbon. In the Elements section, click Buttons and select a style that fits your report. A simple Blank button gives you the most design flexibility.

Alternatively, you can use an image. Just click Image from the same Insert tab and choose a suitable icon from your computer files, like a "reset" or "clear" symbol.

Step 2: Customize Your Button's Appearance With your new button selected, the Format pane will appear on the right. Here you can tweak the design to make its purpose crystal clear.

• In the Style section, under Text, toggle it to On. Enter a label like "Reset Filters" or "Clear All."
• Feel free to add an Icon, adjust the Fill color, or change the Border to match your report's theme. A good user experience depends on intuitive design, so make it obvious what this button does.

Step 3: Assign the 'Reset Filters' Action This is where the magic happens. In the button’s Format pane, turn on the Action toggle. This reveals a set of options.

• From the Type dropdown menu, select Reset filters.
• That’s it! You now have a working reset button.

When a user clicks it, this button will immediately clear all filters and revert all slicers on that specific report page back to their original, default state. It's the cleanest and most recommended method for modern reports.

Method 2: Gaining Full Control with Bookmarks

Before the dedicated "Reset filters" action existed, the go-to method was using bookmarks. While it takes a few more steps, the bookmark approach offers far more flexibility and granular control. It allows you to define exactly what a "reset" means for your report.

Use this method if you want to:

• Reset only specific slicers while leaving others untouched.
• Create a reset button that works across pages.
• Clear filters and also reset other visual states (like sort order or drill-down level).

Here’s how to do it:

Step 1: Tidy Up - Define Your Default State

First, get your report page into the exact state you want it to return to when the user clicks "Reset." This means manually clearing all the slicers and filters that you want the button to control. This captured view is your "bookmark destination."

Step 2: Create the Bookmark

Once your page looks right, you need to save this view as a bookmark.

1. Go to the View tab on the ribbon.
2. Open the Bookmarks pane. It will appear on the right side of the screen.
3. Click the Add button in the Bookmarks pane. A new bookmark ("Bookmark 1") will appear. Rename it to something memorable and descriptive, like "Clear Slicer State".

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 3: Configure Bookmark Settings Correctly

This is the most critical and often overlooked part of the process. An incorrectly configured bookmark can cause unexpected behavior. Click the ellipsis (...) next to your new bookmark's name to see its settings:

• Data: [Must be ticked ON] — This is the key. Keeping 'Data' checked ensures the bookmark saves the current filter and slicer states. If you turn this off, your button won't clear any selections.
• Display: [Usually ticked OFF] — 'Display' saves the visibility state of your visuals. It’s generally best to uncheck this. If you leave it on, and you happened to have a visual selected or a pop-up chart visible when you made the bookmark, pressing the reset button would cause that visual to be re-selected or re-surface every single time.
• Current Page: [Keep ticked ON] — This tells the bookmark to apply only to the current page, which is what you typically want for a page-level reset button.

You can also choose whether the bookmark applies to All visuals or only Selected visuals. For a full-page reset, "All visuals" is fine. For advanced users, selecting just your two or three target slicers beforehand and then choosing "Selected visuals" allows you to create a reset button that only clears those specific slicers — a powerful feature!

Step 4: Connect the Bookmark to a Button

Finally, connect your button to the bookmark you just created.

1. Insert a button just like you did in Method 1.
2. With the button selected, go to the Format pane and turn on the Action toggle.
3. Set the Type to Bookmark.
4. In the Bookmark dropdown that appears, select your bookmark ("Clear Slicer State").
5. You can add a tooltip in the Action card to guide your users, like: "Click to reset report view."

Now, your button will re-apply your saved "clear" view every time it is clicked, giving you a perfectly tailored reset experience.

Comparison: 'Reset filters' Action vs. Bookmarks

So, which method should you use? Here’s a quick breakdown to help you decide.

'Reset filters' Action

Pros: Incredibly fast and simple to implement (just 3-4 clicks). It's the officially supported, modern best practice. Behaves predictably as it resets the entire page context (filters + slicers). Cons: Lacks fine-grained control. It's an all-or-nothing approach for the given page, you can't choose to reset just one of several slicers. Best For: The vast majority of cases where you just need a straightforward "wipe the slate clean" button for a single report page.

Bookmarks Method

Pros: Extremely flexible. You can target specific visuals, control visual properties beyond just filters (like sort order), and design highly customized user interactions. Cons: More setup steps are required. You have to remember to update the bookmark if you ever change your report's default state. It's also easier to make configuration mistakes with the various checkboxes. Best For: Complex reports where you need surgical precision over the reset action, such as dashboards where some filters should "stick" while others are cleared.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Bonus Tip: Create a Dynamic "Filters Applied" Indicator

To take your report to the next level, you can add a simple text indicator that only appears when a filter is active. This gives a subtle cue to the user that the view they are seeing is filtered and reminds them to use the reset button. The easiest way to do this is with a DAX measure.

Let’s say you have primary slicers on your Sales[Region] and Products[Category] columns.

Step 1: Create a DAX Measure

Go to the Home tab and click New measure. Then, enter this simple DAX formula. This formula returns a text message if either slicer is being used, and returns blank if they aren't.

Filter Active Message =
IF(
    ISFILTERED('Sales'[Region]) || ISFILTERED('Products'[Category]),
    "Filters are applied. Click to Reset.",
    BLANK()
)

Step 2: Display the Measure in a Card Visual

1. Go to the Visualizations pane and select the Card visual.
2. Drag your new [Filter Active Message] measure into the Data field of the card.
3. Position this card near your "Reset Filters" button. You can format the text color to be a helpful (but not alarming) color, like a dark blue or light grey.

Now, this message will only appear when a user interacts with your slicers, providing an elegant and high-quality user experience. The message will vanish as soon as they click your reset button.

Final Thoughts

By adding a dedicated button to clear slicers, you empower users to explore your data freely without friction. The built-in "Reset filters" action is perfect for quick implementations, while the bookmark method provides the full control you need for more intricate dashboards. Choosing the right one makes your reporting more intuitive and professional.

Mastering the nuances of a BI tool like Power BI is a great skill, but sometimes you just need to get fast, clear answers from your data without building anything at all. We built Graphed to remove the barrier between questions and insights. We let you connect your marketing and sales platforms (like Google Analytics, Facebook Ads, Shopify, or Salesforce) and simply ask for what you need in plain English. Just prompt, "Show me my top 5 ad campaigns by ROAS this quarter," and we instantly generate the live, interactive dashboard for you so you can skip the setup time and get straight to the analysis.