Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.