Rafael Feo on 14 Jan 2018 09:32:33
When need a button to clear all filters on screen
Administrator on 20 Mar 2018 03:47:38
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/
- Comments (14)
RE: Clear all filters
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.
RE: Clear all filters
How to achieve this in Power BI on premise report server?
RE: Clear all filters
Is there a similar feature to clear all filters when designing reports on Power BI Desktop?
RE: Clear all filters
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.
Please help.
RE: Clear all filters
This was really helpful - we have several instances where our data is not discrete so this function really will help!
RE: Clear all filters
This is possible with bookmarks. Here is a layout from powerbi.tips that illustrates how to clear filters:
https://powerbi.tips/product/layout-cool-blue/
RE: Clear all filters
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.
https://powerbi.microsoft.com/en-us/blog/announcing-persistent-filters-in-the-service/
RE: Clear all filters
Bookmarks with the bookmark set to save "Data" too.
RE: Clear all filters
Like said by Pratik Mudgal, you can achieve this with bookmarks!
RE: Clear all filters
Maybe just clearing slicers would be great. Many reports of mine would lose functionality if all filters were cleared