Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
T_Sad
Frequent Visitor

Sorting of Week Number with custom text

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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thank you for the quick reply.  Saved the day

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors