Forum Discussion
Change order x axis dates
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.
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.
4 Replies
nicolasvc Seems like you need to change your mes column to numeric from text.
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? 😞
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.
