Sorting Week in Table issue

[Anonymous]

Hi guys,

I am currently working on a overview to show the last 5 week of my sales per each customer

How can i sort the  Week column in the table  so i can get the logical order like 50 , 51, 52, 1, 2, 3?

in the following image you can see that the number 2 starts.  this because i currently use the visual filter with filter type Relative Date Filtering to show the items in the last 5 weeks.

Any suggestions? 

Many Thanks 

[LivioLanzo · Accepted solution]

Hi @Anonymous

you will have to add two more columns in your calendar table, one with the 'Year Week' and one with the Week Sequence and then sort Year Week by Week Sequence, you can check out the file I uploaded last week for this post:

https://community.powerbi.com/t5/Desktop/Get-weekly-change-first-hour-in-week-compared-to-previous-weeks/m-p/600111#M285462