Reply
Highlighted
Frequent Visitor
Posts: 6
Registered: ‎05-18-2016

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

Super Contributor
Posts: 4,721
Registered: ‎07-08-2016

Re: sort x-axis month chronologically

@g_reese

 

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

 

sort x-axis month chronologically_1.jpg 

 

Best Regards,

Herbert