Forum Discussion
clear all slicer selection
I want to jump in here with a +1 from me.
Some of our reports are designed for exploration by C-level people, digging around looking at different aspects of the data rather than a smaller more predictable set. For this, we have slicers for just about every variable they may want to look at. But with all those slicers, we really need a single click "clear all" option of some kind.
There is a great workaround using Bookmarks feature, that I implemented recently. Bascially, you just have to create a bookmark, with you default filters (or default view, without any filters/slicers). Insert a shape on that tab, and assign this bookmark to this shape. No matter which filter (page slicers or report fitlers) is selected or enabled, Clicking on this shape will call the bookmark, which had no filters.
Let me know if this helps.
possible to share the example of the pbix file?
- Hi Anonymous,
This is a very nice workaround for single sheet report. Otherwise you need to create a different bookmark for each sheet which is not so pragmatic.
Pbi team should add this functionality as it is a basic one.
Still very nice workaround.
