Forum Discussion
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 end. I need data to reflect Mar - Dec '24, with next month reflecting Jan. '25 following Dec. The source column is formatted as DD/MM/YYYY. How can i reflect this data in chronological order?
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.
