Coding by color

[stefanycheck]

Hi! I think my problem is quite simple. I have a list of status that I want to code by color.  For example:

STATUS	COLOR
STATUS1	red
STATUS2	red
STATUS3	ok
STATUS2	red
STATUS1	red
STATUS4	red

And I wanted a function like, if Table1[STATUS] is equal to STATUS1 or STATUS2 or STATUS4 and so on, equals to RED. If not, equals to OK.

[v-shex-msft · Accepted solution]

HI @stefanycheck,

Conditional formatting already support to use hex value field to color formatting, please take a look at following document:

Conditional formatting in tables

You only need to change text to hex value of color. (for invalid hex value, power bi will use default color format)

Regards,

Xiaoxin Sheng