Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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...
Solved! Go to 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 ,
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