With a Slicer Selection hide Visual?

Question

Let's say I have a Slicer with options A, B, C.

And I have three visuals Table, Chart, Piechart

Is there a way so that if I choose A or B all three show, but if I choose C the Piechart will hide itself?

Thanks,

mfelix · Answer

Hi&nbsp;pftcg,
&nbsp;
You cannot use a bookmark with a slicer but you can do the other way around if you add a bookmark and link it to a selection on your slicer you will get the data and the visuals as you need.
&nbsp;
Check the part of the post where&nbsp; they refer:
&nbsp;
"You can also select whether each bookmark will apply&nbsp;data&nbsp;properties, such as filters and slicers, the&nbsp;display&nbsp;properties such as spotlight and its visibility, and page changes that presents the page that was visible when the bookmark was added. These capabilities are useful when you use bookmarks to switch between visual types - in which case you would likely want to turn data properties off, so filters aren't reset as users change visual types."
&nbsp;
If you want I can try and create an example.
&nbsp;
Regards,
MFelix

mfelix · Answer

Hi&nbsp;pftcg,
&nbsp;
This can be done using the bookmark option. Not really sure on what is underlaing the A, B, C selection but please check the link below and you can get it to work.
&nbsp;
Use bookmarks to share insights and build stories in Power BI
&nbsp;
If you need any further hep please share the model setup and how the slicer also affects the data.
&nbsp;
Regards,
MFelix
&nbsp;

pftcg · Answer

Hey&nbsp;MFelix&nbsp;Appreciate the response but bookmarks don't work with slicers AFAIK. You have to&nbsp;explicitly&nbsp;trigger a bookmark / click the bookmark for it to work correct?Is there a way to make the select action in a slicer&nbsp;go to a specific bookmark?&nbsp;Thanks,

pftcg · Answer

Hey&nbsp;MFelix&nbsp;Yeah but this would be just one other thing for a user to keep track of / cause confusion. I will explore it as an option however.&nbsp;Thank you!&nbsp;For anyone else that stumbles onto this post - it's this idea:https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/14126904-dynamic-visibility&nbsp;

mfelix · Answer

Hi pftcg,I understand what you are saing but slicers are used for data filtering not show/hide visuals because slicer are made from data columns.Don't know how you have your Donut chart setup but maybe if you add a measure that if C is selectd them the data is blank the only question is that your chart should not have any title or legends.In the next release of PBI the conditional formating option will be available for more visuals than only the tables or matrix. Using that you can select in the donut chart to have white values if the C option is selected again your chart cant have titles or legends.Regards,MFelix

Forum Discussion

With a Slicer Selection hide Visual?

6 Replies

Related content

Selected slicer

Slicer default selection

Single select slicer

Slicer selection button color change using native visual

Between date slicer - calender selection