Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
sanman
Helper I
Helper I

Setting background color in weekend columns in a matrix report

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!

 

 

sanman_0-1621629506283.png

 

1 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 🙂 

 

sanman_0-1621706876402.png

 

View solution in original post

4 REPLIES 4
PaulDBrown
Community Champion
Community Champion

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





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






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

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 🙂 

 

sanman_0-1621706876402.png

 

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

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors