Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
Is there a way to clear all current selection (kind of go back to the default slicer setting when the report was loaded) with just one action ?
*Shocked* this still doesn't exist as of January 2018.
Also, will be sending an "issue" -- if Microsoft wants to treat it as such -- that if you, on any type of slicer, turn the "Header" off, you lose the "eraser" functionality to clear the selection.
Hey... the best test environment is production, right?
It's nowhere removed in January 2018 update & check the previous month Update step by step. it will work
Ah ah! I was driving myself mad trying to figure out why the eraser for clearing selections came and went seemingly at radom. At least now I have an answer.
@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
Hi Chetan, Do you any sample to implement this...Please share...thanks...Shishir
@shishir999 I do have. in confidential reports. i will share you once if i get time
Thanks, will wait for it...
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
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?
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
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.
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
Has anyone figured a way to clear all slicers in the Power BI Desktop?
@uzmaa I have not--the closest thing I've seen is the hierarchy slicer (visual gallery) which can be configured to at least have "multiple" slicers in one if you're lucky enough to need slicers organized that way.
I'm also looking for this one click to clear all the selection from various slicers in Power BI Desktop. Instead of going through each of the slicer to click clear button.
Thus anyone has the solution to this?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
89 | |
83 | |
76 | |
64 |
User | Count |
---|---|
142 | |
112 | |
98 | |
98 | |
94 |