The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hey, I have an icon measure and i need to change the colors depending on positive, negative or neutral.
Please, any hint as in the formatting pane there is no option.
Thank you,
Clara
Solved! Go to Solution.
Hi @Anonymous ,
I suggest you to try code as below to create a color measure.
Color =
SWITCH(
TRUE(),
[diff_airticket_YTD]>0,"Green",
[diff_airticket_YTD]<0,"Red",
"Yellow"
)
Try conditonal formatting in your visual and use Field value. Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
I suggest you to try code as below to create a color measure.
Color =
SWITCH(
TRUE(),
[diff_airticket_YTD]>0,"Green",
[diff_airticket_YTD]<0,"Red",
"Yellow"
)
Try conditonal formatting in your visual and use Field value. Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , Is the requirement to change the color of arrows or the color of card visual.