cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vilenm
Frequent Visitor

Slicer to remain filtered when unhiding and hiding visuals

Hi

 

I have 3 buttons that represent 3 different maxtrix table views that are hidden and unhidden when respective button is selected.

But i dont understand when I select an option on a slicer, and click the button the slicer does not remained filtered for the next display of visual that i unhide and hide the previous one. How does one control this as I tried sync slicers that doesnt work when you hide and unhide visuals on the same page

 

thanks

3 REPLIES 3
v-luwang-msft
Community Support
Community Support

Hi @vilenm ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.
 
Best Regards,
Lucien
v-luwang-msft
Community Support
Community Support

Hi @vilenm ,

You could read the following article:

Hidden slicer still filters other visible visuals:https://community.powerbi.com/t5/Desktop/Hidden-slicer-still-filters-other-visible-visuals/td-p/1407... 

 

Example from the article(Just copy from the article):

The first picture is what  want.The sample with 2 bookmarks, where I hide and show Group of "Visuals in BM 1"/"Visuals in BM 2". 

v-luwang-msft_0-1619166006881.png

In reality, while I am viewing Bookmark 1, I click a button to switch to Bookmark 2, then the Country slicer (single select) will be hidden (together with the whole Group "Visuals in BM 1"). Although the Country slicer is hidden, it still affects Group "Visuals in BM 2", resulting in only 1 Country selected country in Bookmark 2. (Please see the second picture).

v-luwang-msft_1-1619166104817.png

What I did is that first, I have to make sure that in Bookmar panel, BM 1, and BM 2 have the Data, Display, and All Visual checked.

v-luwang-msft_2-1619166135861.png

Then in Group "Visuals in BM 1", I delete the Country slicer (single select). As you do with me, if you check now in Bookmark 2, you will see that the Country slicer (Multiple Select) will show all the countries (see picture below).

v-luwang-msft_3-1619166149159.png

 

Now you go back to Bookmark 1, create again the Country slicer (single select), put that slicer back to Group "Visuals in BM 1", then update BM 1 in the Bookmark Panel (see picture below).

v-luwang-msft_4-1619166148888.png

 

Now you should see the final result like the first picture.

 

 

Wish it is helpful for you!

Best Regards

Lucien

MFelix
Super User III
Super User III

Hi @vilenm ,

 

I'm assuming that the buttons are connected to bookmarks, you need to turn off the data option on the bookmark:

 
 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks#using-bookmarks

 

If this option is turn on the bookmark will save the values from when it was created and always will reset the filtering to the ones at the time of the creation.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors