Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Question regarding conditional formatting?

 

Hi

I manage to use conditional formatting one of my matrix table. I use a rule that really simple

If 1column value  (variance) is higher than 0.1 and lower 99999  show its red.

 

I would like to modify for the following

If the column value (variance) is higher than 0.1 and lower 99999  show its red BUT if the variance = the actuals (other column) it should be blank.

 

Any ide how can I manage this? Where should I look at it?

 

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    We can set conditional formatting based on a measure like this.

     

    Measure = var va = MAX('Table'[variance])
var ac = MAX('Table'[actuals])
return
IF(va >=0.1 && va<=99999 && va <>ac,"#FF0027",BLANK())

2 Replies