Forum Discussion
Responsive ResidentConditional visibility of Power BI visual
Microsoft Employee
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.
I'm afraid there's no workaround. You can check this idea Dynamic Visibility and vote it up.
Microsoft EmployeeHere is my rough hack attempt at a show/hide chart
- hansei
Helper V
Phil_Seamarkany chance you rehost that pbix? (link is dead)
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
Better use a Treemap visual... ;-)
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.
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
how fun! thxs :-)
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!
Could you please share the .pbix file for better understanding.
Como lo lograste??
