Change order x axis dates

[nicolasvc]

I have a hierarchy of year, month and week number of the year, for the last 3 months of 2021 and the 12 of the next. When I graph it by year, everything appears well first in 2021, then in 2022, but the problem appears when I go down the hierarchy. Because the order has it per year, but when I have only 2022 it maintains the same order, in the end the months are messy.

Is there a way to put/repeat another value for the axes x with months 10, 11 and 12, but next, something that continues after the 9 only for 2022 and so on. As long as the two years continue every 12 months.

[Greg_Deckler]

@nicolasvc Seems like you need to change your mes column to numeric from text.

[nicolasvc]

Thank you, the order of the months changed, but they still appear together in the same month, how could I do to repeat the axes? 😞

[Greg_Deckler · Accepted solution]

@nicolasvc Oh, take the Ano column out of your Legend and place it in the X-Axis field well above your Mes column to create an ad-hoc hierarchy.

[nicolasvc]

Thanks! I found another way, I switched from the clustered column chart, to the stacked column chart and it magically worked.