x Axis with two dates help please

[Pricey79]

Hello, I was hoping someone could please help me.

I have a stacked column chart and the x axis is currently set to week. What I would like is for the axis to show week number and the current date, as some people like week numbers and some like the actual date.

I have the below date query , but I cant work out how to show both on the axis, could anyone please help?

Thank you

[mahoneypat]

Two ways you could approach this.  You could create a column in your date table that concatenates the Week Number and Date start/end for that week as text, and then use that column in your visual.  Or you could create 2 similar visuals (one with week # and one with dates), and use buttons/bookmarks to show/hide based on user preference.

Pat

[Pricey79]

@mahoneypat  Thank you for your time. Apologies but how would I do this?

''that concatenates the Week Number and Date start/end for that week as text''

[mahoneypat · Accepted solution]

Here is a column expression that shows one way to do it.  You can replace with your date column, and adjust the text as desired (or delete it).

WN and EOW = var wn = WEEKNUM('Date'[Date])

var eow = 'Date'[Date] + 7 - WEEKDAY('Date'[Date])

return "WN " & wn & " EOW - " & eow

Pat

[Pricey79]

@mahoneypat   Thank you very much sir. Much appreciated.