Weekend Row color

[CMSGuy]

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 column I have in the calendar table.  This column is called IsWeekend and will either be a Zero or a One.  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?  Also, I want this gray color whether there is data or not.

[v-xiaotang · Accepted solution]

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]

Would I need to do like an outer join to select ALL dates? 

[Dhacd]

In Conditional Formatting Choose rules instead of a field value and apply the conditions there.
If it is not working Please share a sample dataset and I will have a look.

If this is working for you please mark it as a solution.

Regards,

Atma

[CMSGuy]

How can I share a dataset with you? 

[amitchandak]

@CMSGuy , Field value need a text measure that return color

example 

if(Max('Date'[Weekend]) =1 , "Grey", "White")

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...

[CMSGuy]

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.