Sorting of Week Number with custom text

[T_Sad]

Hello,

In need of help with column sorting on a matrix.

I want to add week number to the date hierarchy.  This is no issue.

Problem I'm having is I want the week number formated like this "Week 1, Week 2, etc.."  
How can I force the sorting on the column to follow the date? Right now it's sorting the column alpha numerically so the report ends on week 6,7,8, etc...

[amitchandak · Accepted solution]

@T_Sad ,

You need to have a numeric week and mark that as the sort column

Week Number = WEEKNUM([Date],2) //Week Number = WEEKNUM([Date],1) // 1 means sunday week

Week Name = "Week " & WEEKNUM([Date],2)

Sort Week name on week number: https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

Refer to my Video Sort and its challenges: https://www.youtube.com/watch?v=KK1zu4MBb-c

[T_Sad]

Thank you for the quick reply.  Saved the day