Forum Discussion
Pareto date axis fix
I'm currently trying to build a pareto chart from a list of dates and I've populated the following table:
| Total Number | Rank | Cumulative Total | Total Incidents | % | Month/Year |
| 25450 | 1 | 25450 | 63275 | 40.22 | Oct 2020 |
| 17602 | 2 | 43052 | 63275 | 68.04 | Apr 2020 |
| 7576 | 3 | 50628 | 63275 | 80.01 | Sep 2020 |
| 4518 | 4 | 55146 | 63275 | 87.15 | May 2020 |
| 3263 | 5 | 58409 | 63275 | 92.31 | Mar 2020 |
| 2920 | 6 | 61329 | 63275 | 96.92 | Aug 2020 |
| 763 | 7 | 62092 | 63275 | 98.13 | Nov 2020 |
| 699 | 8 | 62791 | 63275 | 99.24 | Jul 2020 |
| 484 | 9 | 63275 | 63275 | 100 | Jun 2020 |
My rank is built from the month/year column:
Where i'd like to have the same cumulative frequency line but the Dates in order as when I change it I end up with:
Is there a way to fix this pareto chart with the correct x-axis?
Hi, Anonymous
It’s my pleasure to answer for you.
According to your description,I think you can create a new column,then use it in 'sort bu column'.
Like this:
year/month = YEAR([Event Date])*100+MONTH([Event Date])If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- v-janeyg-msft
Community Support
Hi, Anonymous
It’s my pleasure to answer for you.
According to your description,I think you can create a new column,then use it in 'sort bu column'.
Like this:
year/month = YEAR([Event Date])*100+MONTH([Event Date])If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.