Forum Discussion
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, 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
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
4 Replies
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
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
