Clear all filters
When need a button to clear all filters on screen
Thanks everyone for your feedback. We recently announced Persistent Filters in the Power BI service. As part of this feature, we added a “Reset to default” button that clears all the filters users have applied on the report to the author’s published view. More details here: https://powerbi.microsoft.com/en-us/blog/announcing-persistent-filters-in-the-service/
Chris DeAngelis commented
Hi. I have Persistent Filters checked in the desktop version when I publish so my users' filters aren't saved. My iPad users (after closing and reopening the app) are still seeing differences from the defaults and are able to click the "reset to default" button in their app. I confirmed everyone has the latest app for iOS 12 and persistent filters has been checked for 3 weeks. Is there any evidence of this feature acting differently on mobile apps? Any evidence of this setting being report specific? On the mobile app it appears correctly grayed out on some reports but not others. Thanks for the help! Good feature to have.
How to achieve this in Power BI on premise report server?
Rigel Davis commented
Is there a similar feature to clear all filters when designing reports on Power BI Desktop?
How can i make the "reset to default" the standard way my report appears to anyone opening it? i have tried everything and it still remembers my users filters and they are constantly having to "reset to default" with every tab in the report.
This was really helpful - we have several instances where our data is not discrete so this function really will help!
Mike Carlo commented
This is possible with bookmarks. Here is a layout from powerbi.tips that illustrates how to clear filters:
Kevin H commented
I think the "Reset to default" button, which they just announced, is the solution for this. (Another solution, I should say.) Right?
It doesn't "clear all filters," but instead it takes you back to the default values for all filters/slicers. Which addresses @Luke Walker's point -- typically, you don't want to "clear all"...instead, you want to revert back to the default.
Parth Tanna commented
Bookmarks with the bookmark set to save "Data" too.
Roberto Massucco commented
Like said by Pratik Mudgal, you can achieve this with bookmarks!
Luke Walker commented
Maybe just clearing slicers would be great. Many reports of mine would lose functionality if all filters were cleared
Could be a nice feature. For now in order to clear selections we have to reload report page or as noted below apply a Bookmark with default filter selection.
aditya yadav commented
As a workaround you can use select all feature. Once you deselect the select all feature the slicer clears all selected values.
I was asked the same in my company and I suggested pressing F5 to them. They were happy with this solution.
Pratik Mudgal commented
This can be done using Bookmark feature.