Forum Discussion
Conditional formatting on Strings @ table cells
Hi Anonymous
Let me know whether you'd like to get this:
You can add a measure:
Measure 2 = IF(MAX('Table'[Column1])="KO","#FF0A18",IF(MAX('Table'[Column1])="OK","#15FF00"))Then set the coditional formatting:
Here's another post could be your reference: https://community.powerbi.com/t5/Desktop/Conditional-Formatting-based-on-percentage-of-multiple-values/m-p/720970#M347921
Hi Anonymous
Let me know whether you'd like to get this:
You can add a measure:
Measure 2 = IF(MAX('Table'[Column1])="KO","#FF0A18",IF(MAX('Table'[Column1])="OK","#15FF00"))
Then set the coditional formatting:
Here's another post could be your reference: https://community.powerbi.com/t5/Desktop/Conditional-Formatting-based-on-percentage-of-multiple-values/m-p/720970#M347921
Hello v-diye-msft ,
from my understanding, this measureColorForX works for an existing calculated column, but if you try to create this measure for an existing measureX that is there shown on the column, it doesn't work. Basically if you go to the conditional formatting right clicking measureX that returns OK or KO, select format based on field value and try to select measureColorForX, you can't give an OK and move on.
Maybe i'm missing something, but i simply can't understand why i can't select a background color based on it's content...
Can you help me out?