Forum Discussion
Conditional color formatting for Status field
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
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-values
Hi 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