Forum Discussion

shaunguyver's avatar
shaunguyver
Icon for Helper III rankHelper III
8 years ago
Solved

Reset all filters

I have a Power BI Report with three slicers, that apply to most visuals on the page.

 

I want to include a button at the top of my report that, when clicked, resets all filters to 'blank' (ie with nothing selected).

 

Is there a way to do this using DAX? I understand PowerBI introduced persistent filters, but it looks like this is only accessible in PowerBI control panel (my report is to be published to the web).

 

Thanks

Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Usually people create a Bookmark with everything cleared and then create a button that links to that bookmark.

7 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Usually people create a Bookmark with everything cleared and then create a button that links to that bookmark.

    • shaunguyver's avatar
      shaunguyver
      Icon for Helper III rankHelper III
      8 years ago

      Thanks, I have created a bookmark in my bookmarks pane to clear all bookmarks.

       

      Is there any way to add this to my dashboard, so that an end-user (once it has been published to web) can simply select a button that says 'Clear Filters' and it applies the bookmark?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks Greg! I have added the reset button and it works only when I press Ctrl+ reset button . Is it possible to make it work when someone just presses the reset button?

       

      Thanks,

      Balashenbak V