Conditional formatting X axis categories

[samto22]

Hello!

I'm wondering if it's possible to highlight weekend on X-axis (see e.g. screenshot). I appreciate if somebody could share suggestions how to achieve this. Google doesn't help at the moment 😞

Thanks!

[v-gizhi-msft · Accepted solution]

Hi,

According to your description, i think you can not change part of X axis data's color, but i have a workaround:

Please create a color check measure to change values' color:

Color Check = IF(WEEKDAY(SELECTEDVALUE('Table'[Date]),1)=1||WEEKDAY(SELECTEDVALUE('Table'[Date]),1)=7,"#FF0000")

Then apply it to data values' conditional format:

And it shows:

Hope this helps.

Best Regards,

Giotto Zhi

[samto22]

Thank you, @v-gizhi-msft !