Forum Discussion

afloyd2123's avatar
afloyd2123
Frequent Visitor
4 years ago
Solved

Dynamic Conditional Formatting: Green text for YOY growth, Red text for YOY decline

Hi team, I'd like to use dynamic conditional formatting to show green text for YOY (year over year) growth and red text for a YOY decrease.  For example: 2022 Total Department is less than it was i...
Need Help
  • speedramps's avatar
    speedramps
    4 years ago

    sorry, I gave you a bad DAX measure

     

    Try this ...

     Click here to download a solution 

     

     

    RAG colour =

    VAR myyear = SELECTEDVALUE(yourtable[Year])

    VAR prevyear = myyear -1
    VAR myval = SUM(yourtable[Value])

    VAR prevval =
    CALCULATE(
    SUM(yourtable[Value]),
    ALL(yourtable),
    yourtable[Year] = prevyear )
    RETURN
    IF( myval >= prevval, "Green", "Red")
     
     
     
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

In that case, you can have [RAG color] output 1 or 2 (instead of "Green" or "Red") and then use those to format by Rules (instead of Field value)

afloyd2123's avatar
afloyd2123
Frequent Visitor
4 years ago

When I submit what is pictured I receive the error below.


MdxScript(Model) (337, 5) Calculation error in measure 'Premium'[RAG colour]: DAX comparison operations do not support comparing values of type Integer with values of type True/False. Consider using the VALUE or FORMAT function to convert one of the values.

 

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    4 years ago

    The error seems to indicate that [RAG color] is outputting True or False instead of 1 or 2.