Default State for Slicers

[comish4lif2]

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?

[BITomS]

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.

[comish4lif2]

Thanks 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!

[parry2k]

@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.