Forum Discussion
Solved
Sorting by month name for Date Hierarchy in DirectQuery
Hi guys, I do know date hierarchy is not available for DirectQuery as of now. However I created a custom DateDim table with different columns like (Date, Year, Quarter, MonthNumber, MonthName...
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"?
