cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jessewysong Member
Member

Re: clear all slicer selection

Has this been changed? I used to see the little eraser icon on all slicer selections but now it seems to be gone. They fixed the dissapearing search box in the latest update, has a new problem with the clear button appeared in its place? And now in the desktop I can't figure out how to switch a slicer from a dropdown to a list... It was obvious just a week ago. Am I missing something?

 

best,

Jesse

jessewysong Member
Member

Re: clear all slicer selection

Hi all,

It seems like if I remove the header option, the dropdown vs. list and erase all current selection options dissapear. Super bummer, I have ~ 30 slicers that use title instead of Header to describe whats in them. 

 

best,

 

Jesse

Untitled.png

farhan184 Occasional Visitor
Occasional Visitor

Re: clear all slicer selection

Exactly, that small "eraser symbol" does clear all the selections made in the slicer/ filter, however, as far as the user reviews I received on my dashboard, this icon is very small and difficult to interpret not only because it's small and complex but also that it appears only when you hover over it. Moreover for new users, it's just an alien thing to go for.

 

My CTO actually asked me to figure out a way to creat a larger and clearer button which should clear the selection. I'm still doing my R&D but couldn't find any significant solution.Smiley Sad

RenuKshirsagar Frequent Visitor
Frequent Visitor

Re: clear all slicer selection

Hi @jessewysong,
If you disable the Header field from the Format Painter section under the Visualizations pane then the "Clear Selections" and the small icon to convert slicer visual into a drop-down list or simple list & vice-versa disappears. So enable it and you'll find both the options.  
 
I've highlighted the part where the options appear and the Header section which you need to enable.

Captureslicer.PNGEnable Header switch for Slicer Visual

 

 

 

 

jblackshear Regular Visitor
Regular Visitor

Re: 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.

 

 

xlnerdy Regular Visitor
Regular Visitor

Re: clear all slicer selection

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.

NH Member
Member

Re: clear all slicer selection

possible to share the example of the pbix file?

Highlighted
chethan Member
Member

Re: clear all slicer selection

@BIXL Its very easy bro as simple as that take as eraser icon from https://www.flaticon.com/ & insert the image make it very small size. after this enable the bookmark option & add Bookmark without any slicer selected.

 

Then assign the bookmark name -> select the image > formate image pane >link > enable > Type> bookmark >bookmark >select the namedBookmark

 

 

so its very simple > after that place the blank shape > & assign the bookmark so it look good

 

Revert back if more clarification 

 

Regards,

Chetan K 

BIXL Member
Member

Re: clear all slicer selection

Hi @xlnerdy,
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.
ThomasDay Member
Member

Re: clear all slicer selection

What an awesome idea and a very nice implementation re: eraser. Sure I have lots of tabs.  It even allows a default set of slicers which, honestly, is even better than clear all in some/many situations.  Thanks all!  Tom