Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Change Arrow Assistance

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 someo...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi Anonymous 
    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.

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

Hi Anonymous 
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.