The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to 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 🙂
What measure are you using for the confidtional formatting for weekend values?
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 🙂
Please upload the steps by which you find this solution,Im facing the same issue.