Order Week Year Chronologically

[EsterBR]

Hi,

I have the following table:

I would like to order the field W Week Year chronologically, since when I add it to a visual appear in the following order. The calendar table contains dates for 2023 and 2024.

How can I order it chronologically? Thank you so much!

[PabloVallejo12 · Accepted solution]

I guess you can use the sort by column with date 

[rajendraongole1 · Accepted solution]

Hi @EsterBR - thanks @PabloVallejo12  for sharing your inputs,I  just want to few points,

@EsterBR  select the column Weekyear and sort the column based on weeknumber and order will get automatically based on on

It works , please check .

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[ryan_mayu · Accepted solution]

your week year column is text type. try to change it to year(date)*100+weeknum(date)

then sorty the W week year column by week year column

https://learn.microsoft.com/ms-my/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-deskto...

[rajendraongole1 · Accepted solution]

Hi @EsterBR - thanks @PabloVallejo12  for sharing your inputs,I  just want to few points,

@EsterBR  select the column Weekyear and sort the column based on weeknumber and order will get automatically based on on

It works , please check .

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[PabloVallejo12 · Accepted solution]

I guess you can use the sort by column with date