Forum Discussion

Helper I

3 years ago

Matrix - Date Columns > Conditional Formatting Background when isWeekend

Hello... can someone please help me? I know this is pretty simple but I can't seem to figure this out. I've got a DateDimension that I'm using as my columns.. and I've got a measure that I use on t...

Community Support

3 years ago

If you have a column similar to below "IsWeekend" column in Dimdate table, which has 1 for weekend dates and 0 for working dates,

you can set up the background conditional formatting based on "Sum of IsWeekend". Just like below.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

RT3308
Helper I
3 years ago
Thanks so much for your reply v-jingzhang for that reply 🙂 ... yes I wish it's that easy. My problem is that my matrix values may or may not have values. For example, if my rows are EmployeeNames... then the columns are the dates and some employees don't work on weekends but some do -- this becomes an issue. How do I highlight the background to a color regardless if there's a value in the matrix -- based on column's (DimDate) attribute isWeekend?
- v-jingzhang
  Community Support
  3 years ago
  Hi RT3308
  
  I guess you have a fact table which has employees and their working dates, and this table is connected to the Dim Date table right? Do you have a Dim Employee table? If not, my idea is that you can add a Dim Employee table which has all distinct employees, and connect this table to the fact table on Employee column. Then use this Dim Employee table's Employee column on rows of the matrix visual instead. See if this will help.
  
  Best Regards,
  Community Support Team _ Jing
  If this post helps, please Accept it as Solution to help other members find it.