How can we improve Power BI?

Clear all slicers

Clear ALL slicers on a page with one click, perhaps an addition to a slicer for a clear all slicers button or perhaps a custom visualization that is a button to press to clear all slicers.

1,065 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Kirsty Moffatt shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

49 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Billy Moran commented  ·   ·  Flag as inappropriate

    This one is essential in some reports when you have many filters and many choices in each. It gets very old selecting and unselecting.

  • Greg commented  ·   ·  Flag as inappropriate

    As some have already stated, there is a work-around through the use of bookmarks, but if your report has multiple pages, and you want ALL filtering cleared (report-level slicers AND all visual-level, page-level, drill through-level filters), then you have to create a bookmark for each page, and each page with a button for it. Would be nice if MS included a function that did all the clearing (all pages, all slicers/filters) in one command.

  • Joel Faltermeier commented  ·   ·  Flag as inappropriate

    @ Marco, no this is not the same idea as the persistent filters feature which has a button to "Reset to Default", which is resetting the entire report to it's default saved state by the publisher. This idea is a button to clear all "Slicers" specifically.

  • Colin commented  ·   ·  Flag as inappropriate

    Please add this feature in the next update. Pretty sure this will be in top 10 of feature list.

  • Joel Faltermeier commented  ·   ·  Flag as inappropriate

    Just a thought, I think this is doable with bookmarks now. You can bookmark the data on a page to have all slicers cleared, and link it to an image/shape. You can set it to bookmark all visuals on the page, or only selected visuals (eg only slicers on page, or all slicers/visuals on a page).

  • Filip commented  ·   ·  Flag as inappropriate

    This would really be a useful feature. I would suggest it to be designed similar to the “Applied Steps” function in the Query editor to easily get an overview of applied filters. With the functionality to clear specific filters/slicer choices or to clear all.

  • Jonas commented  ·   ·  Flag as inappropriate

    Without this I find it very hard to replace report built in other reporting tools. Users resist pointing at this deficiency (along with Power Bi’s filter handling in general).

  • Anonymous commented  ·   ·  Flag as inappropriate

    It is important for the users to know which filters are selected and also an option to clear all

← Previous 1 3

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.