change text color with certain text value

[primolee]

Hello everyone,

In my table there is a column showing Sunday to Saturday.  When it is Saturday or Sunday, I want to mark it with different text color or background color.

Is there a way of doing so?  Thank you.

Best regards,

David

[amitchandak · Accepted solution]

@primolee , Create a color measure of your choice, refer to the example. Use that in conditional formatting using "Field Value" Option

Color Weekday = if(FIRSTNONBLANK('Date'[Weekday],blank()) in {"Sunday", "Saturday"},"lightgreen","red")
Color Weekday = if(weekday(max('Date'[Date]),2) >=6 ,"lightgreen","red")

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