Forum Discussion
Helper IShow data by week number
The calendar is separate and more useful that way. In fact, having your week numbers in your fact table may be throwing off the calculation and sort. While I don't have time to fully explain this, at this time, I wanted to at least respond and share a link that could help.
https://www.sqlbi.com/articles/week-based-time-intelligence-in-dax/
Helper IHi Greg_Deckler
First of all, thanks for the reponse.
With the column Week, when i creat a line chart, it will not in the right ordre, i've try to make the week number in type character, but it not works, so do you know how can i do with this?
Community ChampionYuanG - Select your Week column to have a "Sort By" of your WeekNum column.
- YuanG
- Greg_Deckler
Is your WeekNum column set to numeric?
- YuanG
Greg_Deckler Yes, it's numeric. I try with the character it's the same. And i have another question, if the weeks are in right order, it will be like week 1 to week 53, but in fact my data start at week 28 of 2015, so is that possibe in my line chart, the x axe will show in date order? Like week 28 of 2015 to week 53 of 2015 and then weeks of 2016