Forum Discussion
Conditional formatting on Strings @ table cells
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...
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 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