Solved: change visual based on slicer selection

Vickram · ‎02-21-2021

This question has been asked several times but wanted confirmation from the experts if it is possible with the latest update of {ower BI.

As we all know we can hide certain visuals and display others based on button/bookmark. The question is can we do the same based on slicer selection?

Would appreciate any information on this.

parry2k · ‎02-21-2021

@Vickram you can take advantage of the conditional formatting, maybe change the color of the visual such that it is not visible. Look at my blog post here and you can use a similar technique to hide the visuals.

Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

v-shex-msft · ‎02-23-2021

Hi @Vickram,

I think you can use bookmark and selection panel to achieve your requirement:

Using Bookmarks to Show/Hide Information in Your Power BI Report

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

parry2k · ‎02-21-2021

@Vickram you can take advantage of the conditional formatting, maybe change the color of the visual such that it is not visible. Look at my blog post here and you can use a similar technique to hide the visuals.

Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Vickram · ‎02-28-2021

Thanks for your response. At the moment, this seems to be the only solution, but i would prefer if we can use bookmark based on the value selected in the slicer. Hope it will be included in future updates of Power BI..

change visual based on slicer selection

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly