Tabular SSAS - not grouping properly when using a sort by column?

[Anonymous]

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?

[v-yalanwu-msft]

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.

[amitchandak]

@Anonymous , You should sort month by month no, you have sorted by full Date, I doubt that