Forum Discussion
background in conditional formatting
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?
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-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
1 Reply
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-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values