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 ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 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())

v-frfei-msft's avatar
v-frfei-msft
Community Support
6 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())