cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Niiru1
Helper V
Helper V

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 NumberRankCumulative TotalTotal Incidents%Month/Year
254501254506327540.22Oct 2020
176022430526327568.04Apr 2020
75763506286327580.01Sep 2020
45184551466327587.15May 2020
32635584096327592.31Mar 2020
29206613296327596.92Aug 2020
7637620926327598.13Nov 2020
6998627916327599.24Jul 2020
48496327563275100Jun 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:
Pareto.PNG

 

 

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:

 

Pareto1.PNG

 

Is there a way to fix this pareto chart with the correct x-axis?

 

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

1 ACCEPTED SOLUTION
v-janeyg-msft
Community Support
Community Support

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])

3.png4.png

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.

View solution in original post

1 REPLY 1
v-janeyg-msft
Community Support
Community Support

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])

3.png4.png

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.

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.