Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to Solution.
Usually people create a Bookmark with everything cleared and then create a button that links to that bookmark.
Usually people create a Bookmark with everything cleared and then create a button that links to that bookmark.
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
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?
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
105 | |
99 | |
98 | |
38 | |
37 |
User | Count |
---|---|
157 | |
120 | |
74 | |
72 | |
63 |