formatting based on another column

Anonymous , You have to create a color column , but prefer a measure and use that in conditional forammting using field value option

color column =

Switch( True() ,

[column1] >= [Column2] , "Yellow",

//Add others 

"red"

)

 

color Measure =

Switch( True() ,

sum([column1]) >= sum([Column2]) , "Yellow",

//Add others 

"red"

)

 

Not very clear what do you mean by close to

 

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

Hi Anonymous ,

 

This is how I understand your judgment sentence
If column1 is much larger than column2 (ie column1-column2>=1) or column1=column2, the background color is yellow.
If column1 is greater than column2 and close to column2 (ie 0<column1-column2<1), the background color is red.
If column2 is smaller than column2 and close to column2 (that is, -1<column1-column2<0), the background color is black.
If column1 is much smaller than column2 (ie column1-column2<=-1), the background color is blue.

Measure = var _tt=MAX('Table'[Column1])-MAX('Table'[Column2])
return IF(_tt>0&&_tt<1,"Red",IF(_tt=0||(_tt>=1),"Yellow",IF(_tt>-1&&_tt<0,"Black",IF(_tt<=-1,"Blue"))))

 

Reference: Use conditional formatting in tables

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.