Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
BugmanJ
Resolver I
Resolver I

Keeping Slicer Settings when toggling Slicer Visibility Problem

Hi,
Layout and Data is simple:

  • Data is "Shop" is the field in slicer, "Date and Sales" in seperate Graph, all from same data table
  • Toggle Switch (via pictures with Actions) with "On" (as in Slicer is visible) and "Off" (Slicer is not visible)
  • Bookmarks with "Slicerisoff" where Slicer is hidden and "Slicersison" with Slicer visible
  • The "On" toggle is book marked with "Sliceroff" and "Off" is bookmarked with "SlicerOn"

So toggle works just fine hiding and make the slicer visible. Yay. However, I can't keep the slicer choices when I hide the slicer.

I have tried selecting the Slicer and/or graph and going to the bookmark and selecting "selected visuals" and then "update" for both toggles (the off toggle I can only select the graph because the slicer is hidden), but then I can't make it toggle between visible and not visible, only if i removed selected visuals will that work.

What vital step have i  missed please?

Thank you!

1 ACCEPTED SOLUTION
SamWiseOwl
Super User
Super User

Hi @BugmanJ 

In both your bookmark settings you need to turn Data Off.

Otherwise it is saving the slicer selection when the bookmark was created.

 

SamWiseOwl_0-1736427743709.png

 


If you are happy with this answer please mark as a solution for others to find !

Kudos are always appreciated! Check out our free Power BI video courses.

View solution in original post

2 REPLIES 2
v-linyulu-msft
Community Support
Community Support

Thanks for the reply from SamWiseOwl , please allow me to provide another insight:

Hi, @BugmanJ 
Thanks for reaching out to the Microsoft fabric community forum.

Could you please confirm if SamWiseOwl 's response has resolved your issue? Based on my testing, SamWiseOwl 's response is indeed a very effective solution.

Here are my test results:

vlinyulumsft_0-1736759807166.png

vlinyulumsft_1-1736759807168.png

You may need to note that both bookmarks need to have the Data deselected; deselecting only one will not be effective.

vlinyulumsft_2-1736759863274.png

If his response has resolved your issue, I hope you will consider accepting it as the solution

vlinyulumsft_3-1736759863274.png

Please find the attached pbix relevant to the case.

 

Best Regards,

Leroy Lu

SamWiseOwl
Super User
Super User

Hi @BugmanJ 

In both your bookmark settings you need to turn Data Off.

Otherwise it is saving the slicer selection when the bookmark was created.

 

SamWiseOwl_0-1736427743709.png

 


If you are happy with this answer please mark as a solution for others to find !

Kudos are always appreciated! Check out our free Power BI video courses.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.