Forum Discussion
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...
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
2 Replies
- amitchandak
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
Thank you for the quick reply. Saved the day
