Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Week numbers autofilled in chart

Hi all, 

 

I have a weird issue. I basically have values per YearWeek numbers. the YearWeek column is calculated from the date column as follows: 

YearWeek = YEAR('Date'[Date])*100+WEEKNUM('Date'[Date])
This works fine and it returns nicely the YearWeek like 202252, 202253, 202301, 202302 etc. However, when I put the values and YearWeek in a chart for some reason I get numbers like 202254, 202255 etc .. all the way up to 202299, 202300. Of course, the chart is all messed up because now I have gaps beween the years (as attached).
Did anyone encounter this? How can I solve it? 

Best,

2 Replies

  • Anonymous , better to use a categorical Axis, not a continuous

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    It works, thank you 🙂