Setting background color in weekend columns in a matrix report

[sanman]

Hi there,

I have a Event table that I am matching with a DAX calendar table to out put the following report showing the Count of Events for each user using a MATRIX visualization.

I am able to use conditional formatting to change the background color of events that are in weekend, but when there are no events the background color is not applied. 

Two questions: 

How can I apply the background color to all weekend columns? 

Is there any other power BI visuals that will be better for what I need to do?

Thanks for all the pointers!

[PaulDBrown]

What measure are you using for the confidtional formatting for weekend values?

[Ariya]

HasWeekendDate = IF(ISBLANK(MAX('YourTable'[Date])) || WEEKDAY(MAX('YourTable'[Date]),2) >= 6, 0, 1)

[sanman · Accepted solution]

I was finally able to figure it out by creating a getCount measure in the Calendar Table that calculated the count of events plus 0. I found out i had to do plus zero so that it would show zero - otherwise it would show blank.

Then, I put that column as values and conditional formatted it using a color column in the same table and it worked ! 😄 

Thank you for your response. Much appreciated. I know I will need some help again soon 🙂 

[anandsonar1]

Please upload the steps by which you find this solution,Im facing the same issue.