How to reallocate stacks in a column chart?

[Matija258]

Hi.

The numbers on x axis are supposed to represent the number of a month. The text type of months is text and I was wondering if there is a way to reallocate each stack so that their sequence is correct.

Thank you in advance!

[v-yulgu-msft · Accepted solution]

Hi @Matija258,

Based on my understanding, the data type of those values (1,10,11,12, etc) displayed on X-axis is text, right? If so, could you change it to whole number? After changing data type, the sort of these values will be 1,2,3...etc.

If you don't want to change data type and still use this column in chart, please try below workaround.

In Query Editor mode, add a custom column. In my test, it's named as [Index column], remember to set its data type to whole number.

Then, in data view, select [month column], change the "Sort by" option from default to [Index column]

Now, when you add [month column] into axis area, its sequence will be 1,2,3....etc

Best regards,
Yuliana Gu