Conditional formating

[Larry_Wang]

Hi to All,

I want to create a conditional formating for status ( See below picture for details ) and when I want to create rules it seems only can set for value or numbers in a range. Can any one give me some suggestions on how to do this? For example I want to set color for Production as green and Active for blue, etc. 

The format I want in Power BI

Thanks,

Larry

[Anonymous · Accepted solution]

Hi Larry,

Create one calculated column from Status column:

conditional = switch('Table'[status],"Production",1,"active", 2,0)
And apply below conditional formatting on Status column:

Desire Result:

[Maryam_Pour]

Hi Mohityash,
When I'm trying to use your suggested solution, after Switch, my desire table does not appear as an option, only the measures I've created. (see below)
Am I doing something wrong?  

[Larry_Wang]

Hi @Anonymous ,

Thanks for the help on this issue and it works well for me😊

If Power BI allows us to create rule not only for numbers but also for texts, like in this case and it will be better.

Have a nice day!

Larry