cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Responsive Resident
Responsive Resident

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.

 

16 REPLIES 16
Highlighted
Microsoft
Microsoft

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!

Highlighted
Microsoft
Microsoft

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
Microsoft
Microsoft

Re: Conditional visibility of Power BI visual

Highlighted
Frequent Visitor

Re: Conditional visibility of Power BI visual

Better use a Treemap visual... 😉

Highlighted
Responsive Resident
Responsive Resident

Re: Conditional visibility of Power BI visual

@srda:Could you please provide more context about.

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

Highlighted
Frequent Visitor

Re: Conditional visibility of Power BI visual

Dear 

 

Highlighted
Microsoft
Microsoft

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!

Regular Visitor

Re: Conditional visibility of Power BI visual

how fun!  thxs 🙂

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors