Forum Discussion

CMSGuy's avatar
CMSGuy
Helper III
4 years ago
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...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    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.

v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

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.