Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |