Reply
Member
Posts: 186
Registered: ‎05-02-2016

Conditional visibility of Power BI visual

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.

 

Super User
Posts: 2,618
Registered: ‎11-29-2015

Re: Conditional visibility of Power BI visual

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


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Moderator
Posts: 3,051
Registered: ‎03-06-2016

Re: Conditional visibility of Power BI visual


@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.

Highlighted
Super User
Posts: 2,618
Registered: ‎11-29-2015

Re: Conditional visibility of Power BI visual

[ Edited ]
Frequent Visitor
Posts: 2
Registered: ‎06-28-2017

Re: Conditional visibility of Power BI visual

Better use a Treemap visual... ;-)

Member
Posts: 186
Registered: ‎05-02-2016

Re: Conditional visibility of Power BI visual

@srda:Could you please provide more context about.

Frequent Visitor
Posts: 2
Registered: ‎06-28-2017

Re: Conditional visibility of Power BI visual

[ Edited ]

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.

Frequent Visitor
Posts: 3
Registered: ‎07-26-2017

Re: Conditional visibility of Power BI visual

Dear 

 

Super User
Posts: 2,618
Registered: ‎11-29-2015

Re: Conditional visibility of Power BI visual

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


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Visitor
Posts: 1
Registered: ‎06-27-2017

Re: Conditional visibility of Power BI visual

how fun!  thxs :-)