Skip to main content
Microsoft Idea

Power BI

Completed

Clear all slicers

Vote (2191) Share
Kirsty Moffatt's profile image

Kirsty Moffatt on 13 Dec 2016 10:24:20

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.

Zoe Douglas (administrator) on 13 Apr 2023 22:36:58

This was shipped in February 2023: https://powerbi.microsoft.com/blog/deep-dive-into-the-new-apply-all-slicers-and-clear-all-slicers-buttons/.

Comments (67)
Kirsty Moffatt's profile image Profile Picture

Polona Krumpak on 06 Apr 2023 09:51:33

RE: Clear all slicers

Hi,

It would be really, really, really appreciated if the planned action button will work in the dashboard, too.

Clear all filters button (with bookmarks) can be added to the reports, but this button does not work in a dashboard. Or am I missing something???

Kirsty Moffatt's profile image Profile Picture

Oscar Souto Pascual on 28 Mar 2023 07:27:37

RE: Clear all slicers

It's done, nice, and of course is a good improvement, but not perfect, as it only clears the slicers (I know, is in the name) but it doesn't reset the user selections made in the visuals and you know a dashboard is usually full interactive (or even you can use a visual as a filter). I would like a button that reset every filter to set the page at the initial state. I'm afraid I still need to use bookmarks

Kirsty Moffatt's profile image Profile Picture

Carol Witts on 07 Feb 2023 08:11:07

RE: Clear all slicers

Clearing all filters/slicers on all pages of a report seems like a really logical requirement. If we are going to get users to interact with the data, we need to know that they are not going to be confused or concerned there is an error when the "clear all" button clears slicers only on that page and if they look at another page, they aren't seeing the same dataset.

Kirsty Moffatt's profile image Profile Picture

Myriam Wertz on 26 Jan 2023 15:46:44

RE: Clear all slicers

This would also be nice included in the filter pane.

Kirsty Moffatt's profile image Profile Picture

Kieran Leigh on 26 Oct 2022 08:11:20

RE: Clear all slicers

The trouble with using bookmarks is:

  • If new slicers are added to the page, these are not added to the bookmark, so it's easy to get a partially working button
  • There's no way to review bookmarks to see what they affect, so it's hard to check if the bookmark is correct.


One detail here, there is a page I would use this on, but it also has a hidden *sync* slicer. Users would expect a "clear all selection" button to clear the page slicers, but leave the sync slicer alone.

Kirsty Moffatt's profile image Profile Picture

Bobby Lansing on 23 Mar 2022 14:20:52

RE: Clear all slicers

The reset to default button in the web is very handy, functionality like that could be helpful in Desktop.

Kirsty Moffatt's profile image Profile Picture

R T on 16 Dec 2021 12:32:11

RE: Clear all slicers

would be great

Kirsty Moffatt's profile image Profile Picture

Tony Ellis on 13 May 2021 03:03:15

RE: Clear all slicers

other software have this feature

come on get it done !

Kirsty Moffatt's profile image Profile Picture

Rose Ventura on 12 Jan 2021 19:46:22

RE: Clear all slicers

I used bookmarks to clear all slicers on a page, but if you use the SEARCH in a drop-down or list filter. You have to manually remove your entry in the search area.

Seems like an easy fix.

Kirsty Moffatt's profile image Profile Picture

Laura G on 11 Sep 2020 04:09:37

RE: Clear all slicers

As a workaround, we train users to click on on the "Reset to default" option in the web service or mobile app. Since it's part of the interface, it also frees up some space & reduces clutter on the canvas.