Forum Discussion
Solved
x Axis with two dates help please
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...
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
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''
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
mahoneypat Thank you very much sir. Much appreciated.