Skip to main content

Power BI

Completed

Clear all filters

Vote (253) Share
Rafael Feo's profile image

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)
Rafael Feo's profile image Profile Picture

Chris DeAngelis on 06 Jul 2020 00:01:58

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.

Rafael Feo's profile image Profile Picture

maddy on 06 Jul 2020 00:00:06

RE: Clear all filters

How to achieve this in Power BI on premise report server?

Rafael Feo's profile image Profile Picture

Rigel Davis on 05 Jul 2020 23:56:13

RE: Clear all filters

Is there a similar feature to clear all filters when designing reports on Power BI Desktop?

Rafael Feo's profile image Profile Picture

Marjon on 05 Jul 2020 23:42:41

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.

Rafael Feo's profile image Profile Picture

Newelle on 05 Jul 2020 23:18:25

RE: Clear all filters

This was really helpful - we have several instances where our data is not discrete so this function really will help!

Rafael Feo's profile image Profile Picture

Mike Carlo on 05 Jul 2020 23:15:10

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/

Rafael Feo's profile image Profile Picture

Kevin H on 05 Jul 2020 23:14:55

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/

Rafael Feo's profile image Profile Picture

Parth Tanna on 05 Jul 2020 23:14:48

RE: Clear all filters

Bookmarks with the bookmark set to save "Data" too.

Rafael Feo's profile image Profile Picture

Roberto Massucco on 05 Jul 2020 23:14:46

RE: Clear all filters

Like said by Pratik Mudgal, you can achieve this with bookmarks!

Rafael Feo's profile image Profile Picture

Luke Walker on 05 Jul 2020 23:14:32

RE: Clear all filters

Maybe just clearing slicers would be great. Many reports of mine would lose functionality if all filters were cleared