Forum Discussion
Advocate IIDefault State for Slicers
I have been directed to set the slicers to a preset defaulted state. Fine. I can do that,
But in the process of testing and developing and tweaking, slicers get touched.
Is there a way to lock a default state for a slicer or set of slicers?
4 Replies
- parry2k
Super User
comish4lif2 not sure if it is possible, it is part of the development that one should reset the slicer after testing is completed during the development.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
- BITomS
Solution Supplier
Hi comish4lif2 ,
First thing to note in case you were not aware, when you publish a report to the PBI service, the state the slicer selection is in when you publish is a de-facto 'default'. When viewing in the service, there is a reset button within the toolbar.
That said, you can leverage the use of Bookmarks to create default slicer states - Once you create a bookmark, you can add a button to your report canvas linked to the bookmarked slicer selection to restore those defaults. It is worth noting that on Desktop, you will need to hold down CTRL+ Left click in order to get the button to work.
You can find more details on bookamarks here: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks?tabs=powerbi-desktop
This may also be a useful resource: https://radacad.com/clear-all-slicers-in-power-bi-a-bookmark-story
Hope this helps.
comish4lif2Thanks for the answer - yes, I know that the slicers get published with the selections in place when you publish and save - which I why I was hoping there was a way to store a default setting. Set it once and forget it - and not to have to reset it before every save.
Bookmarks are cool - but not while you are still developing/tweaking visuals. You set a bookmark, make some changes before a save, ctrl-click the bookmark - and good luck with the changees you made....
So, no, a default setting is currently not possible. Understood.- BITomS
My only other suggestion would be to set the slicers to what you want and then hide them. Still not what you asked for I know, and has the drawback that you'd need to remember to unhide them before publishing, but possibly helps with your issue.
Perhaps a good one as a feature request to Microsoft!
