Forum Discussion

Pricey79's avatar
Pricey79
Icon for Helper V rankHelper V
5 years ago
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...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    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's avatar
Pricey79
Icon for Helper V rankHelper V
5 years ago

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's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

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's avatar
    Pricey79
    Icon for Helper V rankHelper V
    5 years ago

    mahoneypat   Thank you very much sir. Much appreciated.