Forum Discussion
Anonymous
3 years agoNot applicable
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,
Best,
Anonymous , better to use a categorical Axis, not a continuous
2 Replies
- amitchandak
Super User
Anonymous , better to use a categorical Axis, not a continuous
- AnonymousNot applicable
It works, thank you 🙂