Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
shaunguyver
Helper III
Helper III

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

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

7 REPLIES 7
Greg_Deckler
Super User
Super User

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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

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

Hi

Were you able to make the reset button work on the dashboard as well?

My button is working well on the Report but on the Dashboard:

- if I pin just the button separately to the dashboard, it takes me back to the report

- If I pin the full report on the dashboard, then the button doesn't work

 

Rds

Karla

 

Was there ever a response to how to get the Reset to work on the dashboard and not just the report? @Reset Filters

Hi Balashenbak,

you need to press ctrl+ the button only when you open the report in your desktop version.

Once published, it's enough just to click the button.

Here's a tutorial that describes how to create such a button:

https://livingandcoding.com/blog/create-a-button-to-clear-all-filters-in-power-bi-in-4-easy-steps/

Regards

Anonymous
Not applicable

@mae101 Thanks! 😊

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?

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.