Reset/Clear selected slicers in Power BI Report

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.

  1. Go to View > select Bookmarks
  2. The Bookmarks pane will show up next to Filters. In it, click 'Add' and name your bookmark (ex 'Summary page- Clear filters')
  3. 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)
  4. 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').
  5. 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'.

1

In 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

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

You Might Also Like