Forum Discussion
Conditional Transparency of Visuals
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?
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?
6 Replies
- v-janeyg-msftCommunity Support
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
- AnonymousNot applicable
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-msftCommunity Support
Hello Anonymous
Can you share your related measures? The type of measure affects whether it can be used in it.
Like my sample:
Janey