I have 6 slicers/filter on a Power BI report page ( 5 dropdowns and 1 date slicer). There is a clear all slicer button that resets the all dropdowns and date slicer. Is there anyway, when the clear all slicer button is clicked, all the filters are reset except the date slicer?
Thanks in advance
2 Answers
Yes. You can utilize Bookmarks for this.
- Go to View > select Bookmarks
- The Bookmarks pane will show up next to Filters. In it, click 'Add' and name your bookmark (ex 'Summary page- Clear filters')
- In your page, situate your data exactly how you want it to be when someone hits the Clear button: Clear all filters except for your Date slicer, expand/collapse visuals, etc)
- Insert a button (I usually use the arrow that curves up and backward. In the formatting pane for the shape, I add the word 'Clear').
- In the formatting pane for the button, go to Action. Type: Bookmark, Bookmark: 'WhateverYouNamedIt'
Now when you click your button in the page, it will clear all the filters except the Date.
Anytime you make updates to your page, go ahead and right click on your bookmark and select 'Update'.
1In March 2023, Power bi added a button for that. You can find that under the insert tab- > buttons Power BI March 2023 Apply all Slicer, Clear All Slicer Buttons:
1