Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
86 | |
82 | |
68 | |
65 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |