Week numbers autofilled in chart

[Anonymous]

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,

[Anonymous]

It works, thank you 🙂

[amitchandak · Accepted solution]

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