Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
4 years ago

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?
Need Help
ddpl's avatar
ddpl
Solution Sage
4 years ago

Hi

Changed data type as Date and format as below

 

  • Analitika's avatar
    Analitika
    Post Prodigy
    4 years ago

    I am getting this 

     

    • rohit_singh's avatar
      rohit_singh
      Solution Sage
      4 years ago

      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! ğŸ˜Š