Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have placed a card visual on my report page which I would like to be either white or transparent depending on filter selection
I have trialed the following 2 measures
first trial measure:
GEO Make Transparent =
if( ISFILTERED(TableA[Column A])
&& values(TableA[Column A]) = "Services",
"#FFFFFF00",
"White"
)
2nd trial Measure
GEO Make Transparent 2 =
if( ISFILTERED(TableA[Column A])
&& values(TableA[Column A]) = "Services",
"#FFFFFF00",
"#FFFFFF"
)
The measure works fine but when I try to conditionally format background colour on my card to use the measure all my measures are greyed out and I cannot select any.
Any suggestions?
Thank you
Solved! Go to Solution.
I have resolved by issue. The measure was set to format decimal , I have since set it to text and it now allows me to select it.
Thanks for viewing
@Anonymous
Have you selected multiple values in the slicer? Set Single-Selection on for your slicer.
Your measure looks fine
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
I have resolved by issue. The measure was set to format decimal , I have since set it to text and it now allows me to select it.
Thanks for viewing
Ty!
Hey @Anonymous ,
usually they are always gray.
Can you check if you can still click on them?
I cannot click/ select them.
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |