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

With a Slicer Selection hide Visual?

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,

6 REPLIES 6
Super User
Super User

Re: With a Slicer Selection hide Visual?

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

 



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

Proud to be a Datanaut!




pftcg Frequent Visitor
Frequent Visitor

Re: With a Slicer Selection hide Visual?

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,

Super User
Super User

Re: With a Slicer Selection hide Visual?

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



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

Proud to be a Datanaut!




pftcg Frequent Visitor
Frequent Visitor

Re: With a Slicer Selection hide Visual?

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

 

Super User
Super User

Re: With a Slicer Selection hide Visual?

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


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

Proud to be a Datanaut!




Community Support Team
Community Support Team

Re: With a Slicer Selection hide Visual?

Hi @pftcg,

 

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

With-a-Slicer-Selection-hide-Visual

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.