Forum Discussion
Create reset button in PBI
- 1 year ago
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
-
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:)