Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
i need to create Conditional formatting on cells of a table, and i would like to create something like
if CellValue is OK then show in green, else if cellvalue is KO show in red
I may be wrong, but PBI doesn't seem to accept strings to test/compare, only values and intervals.
Can you help me out?
Solved! Go to Solution.
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?
Hello Ricardo,
I would add an conditional column either with a number (1=OK, 0=NOK) or a color code and based on that hidden column I would colorize your values.
Here a usefull link regarding the colorizing with hex codes
@Anonymous I hope my answer was helpful and may I ask you to mark it as solution/kudo it if that was the case.
I wish you a nice and successful day
BR,
Josef
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |