Conditional visibility of Power BI visual

[Sunkari]

Hi All,

Requirement: Need to show and hide Power BI-visual based on slicer selection. Slicer contains two value bar and line. Based on selection visual should show bar or line chart. We can achieve this based on conditional visibility.

As per my knowledge, conditional visibility is not available in Power BI directly.

Please share the workarounds which are available with you people to achieve this.

[Alina_Fisher]

Here, check out this article,

allows conditional visibility for Power BI card.

https://www.linkedin.com/pulse/show-different-visuals-based-condition-power-bi-alina-fisher

[Embedded82]

Hi everyone, I recently create an idea and asked the team to implement something similar to the SSRS visibility property.

You can vote for it at this link:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/36697297-visibilty-hide-an-item

It would be awesome

[Eric_Zhang]

---

@Sunkari wrote:

Hi All,

Requirement: Need to show and hide Power BI-visual based on slicer selection. Slicer contains two value bar and line. Based on selection visual should show bar or line chart. We can achieve this based on conditional visibility.

As per my knowledge, conditional visibility is not available in Power BI directly.

Please share the workarounds which are available with you people to achieve this.

---

@Sunkari

I'm afraid there's no workaround. You can check this idea Dynamic Visibility and vote it up.

[Phil_Seamark]

Here is my rough hack attempt at a show/hide chart

https://wgtnpowerbi-my.sharepoint.com/personal/phil_wgtnpowerbi_onmicrosoft_com/_layouts/15/guestacc...

 https://app.powerbi.com/view?r=eyJrIjoiYTU1YmI3ZjItZTUyOS00ZTFkLTk5MTctZmMyYmFhNDFhZDIxIiwidCI6ImNlZ...

[theybasar]

Hi, 

Could you please explain how you created a hide and display chart ? I need to apply for it my tables. Looking forward to hearing ffrom you. 

Thank you

[joa_code]

Como lo lograste??

[Anonymous]

Could you please share the .pbix file for better understanding.

[hansei]

@Phil_Seamarkany chance you rehost that pbix? (link is dead)

[Anonymous]

@Phil_Seamark This is great. The only unfortunate thing I've noticed is that when you hide visual A under visual B, everything works as expected, but, when users who should not see visual A open the report on the Service, they see visual A flash up for an instant- not long, but long enough to confuse them. In my case I'm hiding a logo specific to a sub-set of users. The workaround works fine the them, but all other users see something they shouldn't. I guess this really needs a proper implementation!

[ConnieL]

how fun!  thxs 🙂

[pimo]

Dear  Phil_Seamark,

I have downloaded your pbix project, but I cannot understand how it works...
How can you show/hide the white chart according to slicer?

[Phil_Seamark]

Hi @pimo

What you don't see is a giant white pie chart appears or disappears to show/hide the underlying visual.

This was before the advent of the Bookmark feature.  If I needed to do something similar now, I would use Bookmarks to show/hide visuals

[srda]

Better use a Treemap visual... 😉

[Sunkari]

@srda:Could you please provide more context about.

[srda]

Phil_Seamark in the previous post suggested a solution using a Pie Chart, my suggestion is to use a Treemap Chart wich has the advantage of being rectangular. You can use his pbi file and adjust the solution to use a Treemap visual and see wich results serve you best.

[Phil_Seamark]

Hi @Sunkari,

You can strip back a Pie chart to just a single big circle which you can make white.  I think it might be possible to make this disappear or reappear based on a slicer selection to reveal or hide a visual below.

Just a thought

[ksinger2]

Hello @Phil_Seamark ,

Your work-around is great!  The hide/show pane can be overhelming for an end user.  I tried going to the sharepoint site but it did not work.  Could you send me your solution/pbix?

Thank you so much for sharing!

Katie