Forum Discussion
Solved
Weekend Row color
I have a table where I would like the background of a cell to be gray if it is a weekend. The whole row would be gray if it is a weekend. I go into do conditional formatting based on a calculated c...
Hi CMSGuy
Thanks for reaching out to us.
>>However when I go to set up that conditional column, the field is grayed out and cannot be selected. What is happening here? What am I doing wrong?
You need to createt a measure instead of conditional column, for example,
Measure = IF(WEEKDAY(MIN('Table'[date]),2) in {6,7},"grey")result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
