Forum Discussion
How to colour data in table by its value
I have a column in my table that has two outputs: "OOl" or "In Limits". I want it to be red for OOL and green for in limits. I found this measure from another question but not sure what to do with it to apply the colour to my table:
Hi Anonymous ,
You can use conditional formating by colors vaules.
Measure is the same as you provided.
Color Measure = SWITCH(MAX('df_final'[CL OOL]),"In Limits","Green","OOL","Red")
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
CalculatedColumn = IF(column == "OOL", "#41AC4C", "#E42925")mh2587 It returns a syntax error. I just changed the name from column to CL OOL.
Hi Anonymous ,
You can use conditional formating by colors vaules.
Measure is the same as you provided.
Color Measure = SWITCH(MAX('df_final'[CL OOL]),"In Limits","Green","OOL","Red")
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
