Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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.
@Anonymous , You should sort month by month no, you have sorted by full Date, I doubt that
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |