Forum Discussion
Week number by year
Hi!
I have a chart showing trend by week number. However when 2020 began my week 1 is placed at the start of my chart and not as sequal to week 52/53.
I've tried making a "week + year" column but as it is text I cannot arrange it in correct order.
I need;
week 51 (2019) week 52 (2019) week 1(2020) week 2 (2020) etc..
Thanks!
Mikkel
Hey Anonymous
Just create an additional calculated column that contains an integer value like so
yearweekno = year('<tablename>'[date]) * 100 + weeknum('<tablename>'[date])
Then you can use this column to sort your column that contains these valuesweek 51 (2019) week 52 (2019) week 1(2020) week 2 (2020)
This explains the feature "Sort by column": https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column#sort-using-the-sort-by-column-button
The same article also explains how the sort order can be adjusted in visuals.
Hopefully this provides what you are looking for.
Regards,
Tom
6 Replies
- TomMartens
Super User
Hey Anonymous
Just create an additional calculated column that contains an integer value like so
yearweekno = year('<tablename>'[date]) * 100 + weeknum('<tablename>'[date])
Then you can use this column to sort your column that contains these valuesweek 51 (2019) week 52 (2019) week 1(2020) week 2 (2020)
This explains the feature "Sort by column": https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column#sort-using-the-sort-by-column-button
The same article also explains how the sort order can be adjusted in visuals.
Hopefully this provides what you are looking for.
Regards,
Tom
TomMartens Thanks! it worked
- Mariusz
Community Champion
Hi Anonymous
You can add sort by column.
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
