Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
scottkon
Employee
Employee

Date hierarchy monthly drilldown has months out of order

Using PowerBI-Desktop to author a report.  I have monthly data for May 2015 through January 2016.  I started with a daily view and got a request for monthly view as well.  Seems to match what Date Hierarchy does so I switched to that.  The Year view seems ok but the problem is when you drill down I was expecting months to be ordered by year/month but instead it's simply month alphabetical.  So the columns in the chart left to right are January 2016, May 2015, June 2015, etc.  I've been looking to find a solution to specify ordering of the X-Axis but haven't found a solution.

18 REPLIES 18

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.