cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sunkari Member
Member

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.

 

13 REPLIES 13
Phil_Seamark Super Contributor
Super Contributor

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 Eric_Zhang
Moderator

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
Phil_Seamark Super Contributor
Super Contributor

Re: Conditional visibility of Power BI visual

srda Frequent Visitor
Frequent Visitor

Re: Conditional visibility of Power BI visual

Better use a Treemap visual... ;-)

Sunkari Member
Member

Re: Conditional visibility of Power BI visual

@srda:Could you please provide more context about.

srda Frequent Visitor
Frequent Visitor

Re: Conditional visibility of Power BI 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.

pimo Frequent Visitor
Frequent Visitor

Re: Conditional visibility of Power BI visual

Dear 

 

Phil_Seamark Super Contributor
Super Contributor

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!

ConnieL Visitor
Visitor

Re: Conditional visibility of Power BI visual

how fun!  thxs :-)

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 62 members 1,425 guests
Please welcome our newest community members: