Conditional Transparency of Visuals

[Anonymous]

Hello,

I'm looking to create a single report page where I have a single slicer "Supervisor" , and a two visuals, only one of which is visible at a time. The visuals would be two stacked column charts on top of each other.

The default visible visual is a stacked column chart with x axis of Supervisor. When the supervisor slicer is used, I want the visual with x axis as supervisor to be invisible, and another visual (same data, but x axis of employee) to be visible.

I've got it close to working using link below instructions but when I go to select the "make transparent" measure in the fx menu of the background on the visual, I cannot select the measure becuase it is greyed out. Why would this measure be greyed out?

https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/#:~:text=Click%20on%2....

In the screenshots below I have the charts next to each other, but once I get the transparency thing working they would be on top of each other, so that only one at a time can be viewed. Right chart is x-axis of supervisor, left chart is x-axis of employee.

And yes, I also realize this is similar in function to drilling down on a chart, but not quite the same. Any thoughts on how to accomplish this conditional transparency?

[v-janeyg-msft]

Hi, @Anonymous 

“ but when I go to select the "make transparent" measure in the fx menu of the background on the visual, I cannot select the measure becuase it is greyed out. ”

I can't find the background you said. My fx here can use measure normally.

Can you tell which format you modified in which visual? Can you show a screenshot?

Janey

[Anonymous]

Yes,  This is the FX menu I am selecting, and this is what it looks like, greying out the measure I want to select. In that screen cap I searched "make" [for context].

[v-janeyg-msft]

Hello @Anonymous 

Can you share your related measures? The type of measure affects whether it can be used in it.

Like my sample:

Janey

[Anonymous]

Yes,

Here are measures. I put "red" and "white" in after trying several other codes just to see if the values entered mattered.

[v-janeyg-msft]

Hi, @Anonymous 

I don't see the problem so far, but the problem should be in your file.

Here is my sample. You can refer and compare. 

Since I use a table to filter, I change 'isfiltered()' to 'selectedvalue()<>blank()', there is no difference in the essential method.

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,

Community Support Team _Janey

[gash]

Thank you, @v-janeyg-msft - this was perfect, having the sample really helped.  I have it working now.