Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dax

Hi, I have this measure which shows up and down arrows(red) apply to card visual, need a way to change colour to green for up arrow and yellow to diamond unichar, does anyone know how to do this?

GS 1 =
SWITCH (
TRUE (),
ISBLANK ( [Total GS Signups] ) || ISBLANK ( [MoM or WoW GHS selection 1] ), BLANK (),
[MoM or WoW GHS selection 1] * 100 >= 1, UNICHAR ( 128316 ),
[MoM or WoW GHS selection 1] * 100 <= -1, UNICHAR ( 128317 ),
UNICHAR ( 128312 )
)
& ROUND ( [MoM or WoW GHS selection 1], 3 ) * 100 & "%"