Forum Discussion
Sorting by month name for Date Hierarchy in DirectQuery
I can't quite see what your issue is from your description. Per http://databear.com/2016/04/23/power-bi-tips-sort-by-month-name/, you add the Month number column via Power Query editor (i.e. "Edit Query"), but the sort itself is set in the report editor under the Modelling tab - the sort doesn't happen in "Edit Query"?
Yes u r correct .
If it is default Hierarchy it will short fine.
If u create any custom hierarchy u have to create short order for all level. so here u have to create one more extra column for month. and apply that column to month short.
like Example :
Switch (Month,"Jan",1,"Feb",2, etc...)
let me know if any help
I can't quite see what your issue is from your description. Per http://databear.com/2016/04/23/power-bi-tips-sort-by-month-name/, you add the Month number column via Power Query editor (i.e. "Edit Query"), but the sort itself is set in the report editor under the Modelling tab - the sort doesn't happen in "Edit Query"?