Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

font color conditional formatting

hi 
i want to show - values in green color nd +ve values in red color
what is the condition i need to use in font color conditional formatting.

 

  • Anonymous's avatar
    Anonymous
    5 years ago
    Hello Anonymous,
    Create a measure like this and use in conditional formatting.
    Measure = IF(MAXX(Sheet1,Sheet1[percent])<0,"#73B761","#de6a73")
     

     

3 Replies

  • Anonymous , You can try rule base

    like

    -100 to  0 (absolute value, assuming this % column] red

    0 to 100 , green

     

    Or a color measure

    color  = if([chnage%] <= 0, "Red", "Green")

     

    use that in conditional formatting using field value option

  • Anonymous's avatar
    Anonymous
    Not applicable
    Hello Anonymous,
    Create a measure like this and use in conditional formatting.
    Measure = IF(MAXX(Sheet1,Sheet1[percent])<0,"#73B761","#de6a73")
     

     

  • themistoklis's avatar
    themistoklis
    Community Champion

    Anonymous 

     

    If you want to apply a conditional formatting on the field in a table or matrix you can do it directly though table options instead of creating a new field.

     

    See image below. It is a rule based formatting