Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Conditional Formatting

Hi all, I want to ask why my conditional formatting is not working. This is my matrix and the conditional formatting. The orange arrow should be in green as it exceeds 15%. Thank you so much.   ...
color
Conditional Formatting
DAX
  • az38's avatar
    az38
    6 years ago

    Anonymous 

     try to compare with Number, not Percent

az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

there are much more in Conditional Formatting dialog box, please show.

 

Bytheway, I see your last row has Number as Unit, not percent. Im not sure it will work correct

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi az38, here is the full conditional formatting dialog box. The number at the end of the condition does not affect the icon/colors even if I remove it. I've tried it before w/o the last condition and it still doesn't work. The only problem is the numbers greater than 15 are marked as orange icon while it should be green icon.

     

    • az38's avatar
      az38
      Community Champion
      6 years ago

      Anonymous 

      what is [GP Growth %] field? is it a measure? do you use CALCULATE()?

      and do you like green arrows in values like 900%? your rule should cut it off

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        az38 

         

        Yes it is a measure field. Here is the formula and yes I do use the CALCULATE() function. GP YTD and GP LY also are measure field.
        Green arrow stopped at 100% btw.

        GP Growth % = if(and([GP YTD] =0,[GP LY]=0),0,if(and([GP YTD] >=1,[GP LY]=0),1 ,if(and([GP YTD] =0,[GP LY]<=0),1,if(and([GP YTD] <=-1,[GP LY]>=0),-1,if(and([GP YTD] >=1,[GP LY]<=0),CALCULATE(([GP YTD]-[GP LY])/-([GP LY])),CALCULATE(([GP YTD]-[GP LY])/[GP LY]))))))