Forum Discussion
Create reset button in PBI
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
-
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!