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 ...
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.
v-janeyg-msft
Community Support
Community SupportHi, 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.