How to highlight Saturdays only in Matrix table?

[Iwona]

Hi all,

I need help with my matrix table. I need to highlight only Saturday based on chosen month from the slicer. ( example below shows Saturdays in chosen months from slicer - July).

Iwona_forum_slicers.pbix (215.7 KB)

Was trying to use “if statement” , and conditional formatting but had no success.
Does anyone of you have any clue how I should sort it out?

Grateful as always ,

Iwona

[mspanic]

Hi @Iwona

1. Create measure - to pick color if Day of Week is Saturday (WeekNumber =5)

IsSaturday = IF (Max(‘Calendar’[Day of Week Number]) =5,"#845EC2")

2. Matrix to conditional formatting → Background color

And use this measure

to get

PBIx:
Iwona_forum_slicers_v1.pbix (214.3 KB)

Best regards,
Maja

[Iwona]

Hi @mspanic

Huge and deep thanks to you for your amazing job and clear and concise explanations.
Grateful for your help and support.

Many thanks, Iwona