Change Date x-axis value colors by weekday() - NOT BARS, the axis itself

[jam17]

I have a table I'm using to track clicks per day, and I think it would be useful to have some indicator for which days were weekends.

I was thinking I might be able to do this by writing a measure with hex codes like this:

Measure = IF(OR(WEEKDAY(_____('Date Table'[Date]))=1,WEEKDAY(______('Date Table'[Date]))=7),"#C8C8C8","#223D64")
But I can't figure out what function to put in the ________.  

The ultimate goal would be to have weekdays in the x-axis labels to be blue and the weekends (e.g. Oct 19 and Oct 20) to be grey.

[jam17]

I tried both SELECTEDVALUE and MAX, but that resulted in everything being changed.

Also, I'm not looking to color the bars (as I'm never expecting there to be clicks on those days), but instead the dates themselves, as a quick indicator to my stakeholders that they shouldn't expect clicks on those days, because it's the weekend.

[FreemanZ]

hi @jam17 ,

that is a valid requirement, but seems not realised yet.

https://ideas.powerbi.com/ideas/idea/?ideaid=1d079693-f703-ec11-b76a-281878de77da

https://community.fabric.microsoft.com/t5/Desktop/Conditional-formatting-of-X-axis-values/td-p/26758...

[jam17]

Thanks.  Upvoted.

[wini_R]

Hi @jam17,

Beside MIN/MAX aggregators mentioned by FreemanZ, it would also work with SELECTEDALUE()

[FreemanZ]

hi @jam17 ,

try to fill it with MAX or MIN.