Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Continuous Year Week on line chart

Hi,

 

I have a date table in my model, where one column is a concatenation of the year and the week ( = [Year] & "-" & [WeekOfYear]).

 

I want to use this column in the X-axis on my line chart. But I want to see all my data at once (no scroll bar). I know I can do this with a date field and a Continuous X-Axis. But I can't select continuous on the YearWeek column. 

 

Any suggestions?

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous , you can try with the week start/end date. But that is another date.

     

    Mon-Sun

    Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
    Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)

     

    Sun-Sat

    Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date])+1
    Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date])