Forum Discussion
Sorting year weeks in Power BI
Hello, I would like to ask how to properly sort year week because in visual it seems unsorted: Here is the view of it Is possible to fix it?
I am getting this
Hi Analitika ,
Please create a new column on your date table like below :
YearWeekIndex = dim_date[Year] * 100 +dim_date[Week of Year]
Then select your YearWeek column, go to sort by column and click on 'YearWeekIndex'. Your yearweek field will now be sorted using this column.
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 😊