Forum Discussion
Conditional formatting based on value in another column
Peter_2020 , Try like
if(max(table[PERFORMANCE]) <Max(Table[TARGET]) , "Red", "Green")
or
if(average(table[PERFORMANCE]) <average(Table[TARGET]) , "Red", "Green")
Peter_2020 , Assuming [PERFORMANCE] and [TARGET] are measures
then create a color measure and use that in conditional formatting with field value option
if([PERFORMANCE] <[TARGET] , "Red", "Green")
refer for step
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
Performance and Target are columns from imported excel table...
Peter_2020 , Try like
if(max(table[PERFORMANCE]) <Max(Table[TARGET]) , "Red", "Green")
or
if(average(table[PERFORMANCE]) <average(Table[TARGET]) , "Red", "Green")
It works!!! Thank you very much!
