slicers should remain constant even after the action performed by Buttons and Bookmarks

[Anonymous]

Hi All,

I have one common slicer, 2 buttons and 2 Tables.

As of now if i click Button 1 then table 1 will show i.e., Table 2 will get hide.

If i select Button 2 Table 1 is showing up i.e., Table 1 is getting hided. This is how my current functionalit is working and it is working as per my expectations.

 if i selected Button 1 and selected year in slicer as 2018 then table 1 is populating 2018 year data alone. That is what i am expecting. But if i select Button 2 then i want slicer to remain constant at 2018 (why beacuse previously is selected 2018) and i want table 2 to show 2018 data alone. Same as if i selected 2017 and then i am clicking button 2 means then Table 2 needs to show 2017 data alone. How to do that?

Currently i bookmarked Button 2 (table 2) to show up "All" values in slicer thus if i select button then by default it is showing all.

How to control slicers while doing bookmark?

Thanks in Advance

[Gordonlilj · Accepted solution]

Hi,

If i understand correctly, you don't want the slicer to change the filtered value but to remain while switching between bookmarks.

If so then you could try and uncheck data on the bookmarks

Unchecking it means that the bookmarks does not apply to filters

[Anonymous]

@Gordonlilj  Thanks for your reply.

What does Display, Current Page, all visuals do?

Thanks

[Gordonlilj]

The display options is about spotlighting and selection pane settings.

Current page saves the page for the bookmark.

The all visuals regards which of your visuals will be affected by a bookmark.

You can read more about it below

Create bookmarks in Power BI Desktop to share insights and build stories 

Bookmarks - What are they, and why should you care?