With a Slicer Selection hide Visual?

[pftcg]

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,

[v-jiascu-msft]

Hi @pftcg,

How about adding three Bookmark buttons? Please refer to the snapshot below.

Best Regards,
Dale

[MFelix]

Hi @pftcg,

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.

Use bookmarks to share insights and build stories in Power BI

If you need any further hep please share the model setup and how the slicer also affects the data.

Regards,

MFelix

[pftcg]

Hey @MFelix

Appreciate the response but bookmarks don't work with slicers AFAIK. You have to explicitly trigger a bookmark / click the bookmark for it to work correct?

Is there a way to make the select action in a slicer go to a specific bookmark?

Thanks,

[MFelix]

Hi @pftcg,

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.

Check the part of the post where  they refer:

"You can also select whether each bookmark will apply data properties, such as filters and slicers, the display 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."

If you want I can try and create an example.

Regards,

MFelix

[pftcg]

Hey @MFelix

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.

Thank you!

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

[MFelix]

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