cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
regasanyoto Member
Member

Sorting Week in Table issue

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 

 

 

last 5 week trends.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Sorting Week in Table issue

Hi @regasanyoto

 

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-w...

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

1 REPLY 1
Highlighted
Super User
Super User

Re: Sorting Week in Table issue

Hi @regasanyoto

 

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-w...

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!