Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |