Putting stacked column chart in order

[e175429]

Ok, this is my current chart:

I want it so that the tenure goes in order from "less than 6 months" to "more than 10 years".

I have 2 options to sort on the axes. When I chose either of them and choose ascending, I still don't get the correct order axes.

[v-linyulu-msft · Accepted solution]

Hi,@e175429 

Regarding the issue you raised, my solution is as follows:

1.First I have created the following table and the column names and data are the data you have given:

 2.Then the bar graph currently generated is as follows:

3.First go to the Power Query page and click the button below to enter the sort number according to your requirements:

4.Then click on the column that you want to sort and change the position in the image below

5.Finally, you just need to regenerate the visualization, and here is the new resulting diagram:

You may want to note that the type of column you need to sort may not work if it is a number.

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.