background in conditional formatting

[space83]

hello guys.

I got a simple questions based on my table below:

In status fields, how can i set a background color as RED for status == In production and backgroud as GREEN FOR status == Product completed?

[amitchandak · Accepted solution]

@space83 , Create a color measure like

Measure =
Switch(true(),
max(Table[status]) = "In production" , "Red" ,
max(Table[status]) = " Product completed" , "Green" ,
"blue "
)

And use it in conditional formatting using "Field Value" option

you have to do it for each column you want color

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values