Forum Discussion
Advocate IIDefault State for Slicers
Solution SupplierHi 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!