Change Arrow Assistance

[kimdiep503]

The current statement for the change arrow is functioning correctly, with the exception of the color not changing to red when the arrow indicates a downward change (i.e. a negative number). Can someone help see what I did wrong? Thank you

Change Arrow= IF( [Preceding Week Change] >=0 , UNICHAR(9650), UNICHAR(9660) )

Not sure if it's because the callout value for 'Change Arrow' is set to green which is why it's not changing to red?

[Ritaf1983 · Accepted solution]

Hi @kimdiep503 
The unichar function just returns an icon.

For the color you can use Similar dax :

Change Arrow= IF( [Preceding Week Change] >=0 ,"GREEN", "RED" )

* The color can be the word / hexa code

and then modify it from conditional formatting

Result :

Pbix with example is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.