Pareto date axis fix

[Niiru1]

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:

Rank = IF(

ISBLANK('Sheet1'[Total Number]) || NOT HASONEVALUE('Sheet1'[Month/Year]), BLANK(),

RANKX(ALL('Sheet1'[Month/Year]), ([Total Number])))

However I keep ending up with this:

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?

https://www.dropbox.com/s/c3hfci8jabydxv1/Pareto.pbix?dl=0

[v-janeyg-msft · Accepted solution]

Hi, @Niiru1 

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.