Forum Discussion
Tabular SSAS - not grouping properly when using a sort by column?
I have a tabular model with a date hierachy showing month name and year, I am sorting the monthname by my fulldate (so they dont' appear in alphabetical order in PBI) however when I drag measures against this hierarchy it isn't grouping properly.. see the attached image
Is there something obvious I am doing wrong?
2 Replies
Anonymous , You should sort month by month no, you have sorted by full Date, I doubt that
Hi, Anonymous ;
You could try sort by another column (Date).
Select Sort by Column, then select the field you want to sort the other field by, in this case, Date.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
