Forum Discussion
Analitika
Post Prodigy
Post ProdigySorting 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?
AnalitikaPost Prodigy
Post ProdigyI am getting this
rohit_singh
Solution Sage
Solution SageHi 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! 😊