Forum Discussion
highlight weekends in matrix
Here is one way I found to work.
On your Date table, add a column with this expression
Day Color = IF(WEEKDAY('Date'[Date])=1, "Red")
Then, concatenate the expression in your measure that goes in the values area with & " "
Measure = SUM(Table[Column]) & " "
Then add conditional format to that measure in the matrix, choose Field Value, and your Date[Day Color] field (it will default to First aggregation).
Here is an example I what I saw when I did the above (note one value is blank but still show red).
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
parry2k , mahoneypat any ideas in this matter?
Microsoft EmployeeHere is one way I found to work.
On your Date table, add a column with this expression
Day Color = IF(WEEKDAY('Date'[Date])=1, "Red")
Then, concatenate the expression in your measure that goes in the values area with & " "
Measure = SUM(Table[Column]) & " "
Then add conditional format to that measure in the matrix, choose Field Value, and your Date[Day Color] field (it will default to First aggregation).
Here is an example I what I saw when I did the above (note one value is blank but still show red).
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
- mahoneypat
Measures can sit in any table, but it is not in same table. This simple model that I use when working on community solutions is described here.
The shown matrix uses the Date, Product, and Sales table from that model.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat