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.
- Comments (58)
RE: Clear all slicers
I can't believe this doesn't already exist. Please do! Thanks.
RE: Clear all slicers
Absolutely a must-have!
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.
RE: Clear all slicers
Plase allow this to work on custom visuals filters as well.
RE: Clear all slicers
A must-have!
RE: Clear all slicers
also return all hierarchies to top level
RE: Clear all slicers
Must have! Please include it in the next update
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.
RE: Clear all slicers
Yes! I create this manually using bookmarks for each sheet, it works but its tedious!
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.