Skip to main content

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

EOS Solutions Luca De Pol on 05 Jul 2020 23:45:55

RE: Clear all slicers

Absolutely a must-have!

Kirsty Moffatt's profile image Profile Picture

Billy Moran on 05 Jul 2020 23:44:39

RE: Clear all slicers

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

Kirsty Moffatt's profile image Profile Picture

Thiago Donato on 05 Jul 2020 23:39:29

RE: Clear all slicers

Plase allow this to work on custom visuals filters as well.

Kirsty Moffatt's profile image Profile Picture

Schwanitz on 05 Jul 2020 23:39:25

RE: Clear all slicers

A must-have!

Kirsty Moffatt's profile image Profile Picture

Power BI User on 05 Jul 2020 23:35:46

RE: Clear all slicers

also return all hierarchies to top level

Kirsty Moffatt's profile image Profile Picture

Power BI User on 05 Jul 2020 23:35:08

RE: Clear all slicers

Must have! Please include it in the next update

Kirsty Moffatt's profile image Profile Picture

Greg on 05 Jul 2020 23:32:04

RE: Clear all slicers

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.

Kirsty Moffatt's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:25:50

RE: Clear all slicers

Yes! I create this manually using bookmarks for each sheet, it works but its tedious!

Kirsty Moffatt's profile image Profile Picture

Joel Faltermeier on 05 Jul 2020 23:16:12

RE: Clear all slicers

'@ 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.

Kirsty Moffatt's profile image Profile Picture

Marco Smulders on 05 Jul 2020 23:15:58

RE: Clear all slicers

Isn't this idea the same as clear all filters? If so, it will be completed soon. See: https://powerbi.microsoft.com/en-us/blog/announcing-persistent-filters-in-the-service/ .