Showing results for 
Search instead for 
Did you mean: 
luigi_dgv Frequent Visitor
Frequent Visitor

Re: Date hierarchy monthly drilldown has months out of order

In the chart area, once the hierarchy is on the axis, drill up to the least granular level.
Then on the top left corner click the icon representing a bi-forked arrow ("Expand all down one level in the hierarchy"). That will concatenate year and month in the proper way on the axis, maintaining the correct (date-based) sorting.

Re: Date hierarchy monthly drilldown has months out of order


@luigi_dgv ,

No, it does not.

Even if the dim table is sorted in the correct order, months are sorted alphabetically.

Some answers say to adjust the sort order at each level in the hierarchy but, how??  This information is not coded in our DNA...

The sort by column is disabled when you select the hierarchy level so, how to sort?


Turns out you need to select the actual field (not the version in the hierarchy) and the sort option then becomes active.  If you select Month (text version) then click on Sort by Column in the Modelling tab and select Month Number (you need to include this in your Date table), then it will work.

Helpful resources

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 275 members 2,856 guests
Please welcome our newest community members: