Create reset button in PBI

[masterpbi]

Hi everyone,

As far as I know, we can create a reset button in Power BI using the default “Clear all slicers” option or by using a bookmark. My report requires having two buttons: “Apply Filter” and “Reset Filter”. For “Apply Filter”, I’m using the default “Apply all slicers” button.

My problem:

• If I create the “Reset Filter” button using the default “Clear all slicers” option, I can’t revert the slicers to the specific default values I want. It just clears all slicers and returns them to “All”.

• If I create the “Reset Filter” button using a bookmark, there’s another issue. When users select values in the slicers but haven’t clicked “Apply Filter” yet, the slicers won’t revert to the default values when they click “Reset Filter.” They must click “Apply Filter” first, then “Reset Filter,” which is very inconvenient.

Is there any workaround for this problem?

Thank you so much!

[v-nmadadi-msft]

Hi @masterpbi 

As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestions  provided by the community members for the issue worked. Please feel free to contact us if you have any further questions.

Thanks and regards

[v-nmadadi-msft]

Hi @masterpbi ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[v-nmadadi-msft]

Hi @masterpbi 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[MasonMA]

@Ananth_Kumar_BS , @grazitti_sapna 

Could any of you provide @masterpbi with a sample file ? 

I tested these before I left a message and it seems super tricky to get things set up. 

[grazitti_sapna]

Hi @masterpbi 

Yes there is limitations of both “Clear all slicers” and bookmark-based approaches in Power BI when trying to create a fully functional "Reset Filter" button that restores specific default slicer values, not just "All".

But still try the below approach: 
1. Create two slicers:

• Slicer Set A – Default values set → This will be visible by default.
• Slicer Set B – Slicers used by the user to make selections → This is normally hidden and shown only after clicking “Apply Filter”.

2. Create Bookmarks:

• Bookmark 1: Default View (Reset State)
• Show Slicer Set A
• Hide Slicer Set B
• Set visuals and filters as needed
• Enable "Data" and "Display" (uncheck "Current Page" unless needed)

• Bookmark 2: Applied Filters View
• Hide Slicer Set A
• Show Slicer Set B
• Enable "Display" only (do not check "Data" to preserve user selections)

3. Add Buttons:

• Apply Filter → linked to Bookmark 2
• Reset Filter → linked to Bookmark 1
  
  

 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

[rohit1991 · Accepted solution]

Hi @masterpbi 

Yes this is a known limitation in Power BI. Right now, there’s no built-in way to have both an "Apply Filter" and a "Reset Filter" that takes slicers back to specific values especially if the slicers haven’t been applied yet.

The "Clear all slicers" button only resets everything to "All", and bookmarks won’t behave as expected unless filters are applied first which can be frustrating.

What usually works is setting up two bookmarks:

• One for your default state (with slicers pre-selected)

• Another for the filtered state

Then link them to two buttons:

• Apply Filter - linked to the filtered view

• Reset Filter - linked to the default view

[Ananth_Kumar_BS]

You're right — this is a known limitation with the "Apply all slicers" feature in Power BI. When you use it, slicer selections aren't committed until the user clicks "Apply," which means the bookmark method for resetting filters only works after the slicers have been applied. This can cause confusion for users who expect the "Reset" button to work regardless of whether they clicked "Apply" or not.

However, there’s a workaround suggested in the official documentation:
👉 Hide the Apply all slicers button with a bookmark

As mentioned in the article, one option is to let the report consumer decide how they want slicers to behave. You can do this by toggling visibility of the "Apply all slicers" button using a bookmark, giving users the flexibility to either apply filters manually or have them applied instantly.

So, instead of forcing a fixed workflow, consider:

• Using two bookmarks: one with "Apply all slicers" visible and one hidden

• Letting users choose between manual or instant slicer application via toggle buttons

• Pair this with a "Reset" button tied to a bookmark that sets all slicers to your predefined default state (not “All”)

This approach provides a more intuitive experience and avoids the issue where slicers can't be reset until they’re applied.

Hope that helps!

[MasonMA]

Hi @masterpbi 

Exactly, a bit tricky with 'Apply All Slicer'. I would not use 'Apply Filter' button unless my report is built on DirectQuery with large data model and the report is very slow in performance when users are making their filter selections. 

I'd suggest removing this button to simplify your report development:)