Forum Discussion
Solved
PivotChart dates out of order
I'm currently tracking # of monthly issues submitted in line graph (per below attachment). Now that new year has started, any issues opened in Jan. '25 are appearing at beginning of graph instead of...
In Power Pivot you may add column as
MonthId = Table1[Date (Year)]*100 + Table1[Date (Month Index)]after that select Date (Month) column and Sort By column MonthId
Result looks like
It works if period is from Mar one year to Feb next year (or any 12 months period). If chart will be continue on Mar 2025, etc - Year shall be added to X-axis.
In Power Pivot you may add column as
MonthId = Table1[Date (Year)]*100 + Table1[Date (Month Index)]after that select Date (Month) column and Sort By column MonthId
Result looks like
It works if period is from Mar one year to Feb next year (or any 12 months period). If chart will be continue on Mar 2025, etc - Year shall be added to X-axis.