Forum Discussion

g_reese's avatar
g_reese
New Member
9 years ago

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

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    g_reese

     

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

     

     

     

    Best Regards,

    Herbert