Forum Discussion
Helper Vchange text color with certain text value
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
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-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
1 Reply
- amitchandak
Super User
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-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values