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.

  • CMSGuy's avatar
    CMSGuy
    Helper III
    4 years ago

    Thanks for the reply Dhacd .  What do I do if no data was entered for that day?  This is a sample with some test data and only one day for this month of July has data.