Forum Discussion
Conditional color formatting for Status field
Hello
I have one column i.e. status where I want to set the background color depending on value as mentoned below
Completed - So color should be Green
Work in Progress - Color should be Amber
Not Started - Color should be Blue
Failed - Color Should be Red
I checked the conditional formatting but did not found any option depending on the text value. It is mainly showing on count and total.
Regards
Sona
Hello
I found same type of solution in another post
https://www.sumproduct.com/blog/article/power-bi-tips/power-bi-conditionally-formatting-from-text
If you any better example is there, please let me know.
Regards
Sona
3 Replies
Sonashish , Create a color measure and use that in conditional formatting using the "Field value" Option. Table and Matrix in conditional formatting. In other visual in data color , when you do not have Legend and multiple measures
Color Status =
Switch(true(),
max(Table[Status]) = "Completed", "Green",
max(Table[Status]) = "Work in Progress", "Amber",
max(Table[Status]) = "Not Started", "Blue",
max(Table[Status]) = "Failed", "Red",
"White"
)Refer steps
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-valuesHi Amit,
I followed same which was posted in url which was shared by me, but MS url is better one. This is also works. Thanks
Sona
Hello
I found same type of solution in another post
https://www.sumproduct.com/blog/article/power-bi-tips/power-bi-conditionally-formatting-from-text
If you any better example is there, please let me know.
Regards
Sona
