Forum Discussion

Pricey79's avatar
Pricey79
Helper 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
mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

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

      mahoneypat   Thank you very much sir. Much appreciated.