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
g_reese
New Member

sort x-axis month chronologically

I have a stacked column chart with a date hierarchy as the x-axis values.  Chart is showing the Month date hierarchy values.  Problem is that there's three months November, December, and January.  Nov & Dec are for year of 2016 and January is for 2017.  January should be third but instead the chart sorts by alphabetical order.  I see no chart option to sort my x-axis labels by chronological order.  This seems like something people will encounter often.  There should be a simple way for users to to fix this in their powerbi charts that use a date hierarchy.  By the way, the image I added below is blank on this post editor, not sure if it will show up after I post. 

 

imageimage

1 REPLY 1
v-haibl-msft
Employee
Employee

@g_reese

 

You can expand all down one level in the hierarchy as below.

 

sort x-axis month chronologically_1.jpg 

 

Best Regards,

Herbert

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.