Cumulative Frequency curve adjusted x axis

[Anonymous]

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

[mahoneypat · Accepted solution]

You can use the measure expression below for your line value, along with the Event Date on your X-axis (not the hierarchy) to get the shown pic.

Cumul Events =
VAR thisdate =
    MAX ( Sheet1[Event Date] )
RETURN
    CALCULATE (
        [Total Number],
        ALL ( Sheet1[Event Date] ),
        Sheet1[Event Date] <= thisdate
    )

Regards,

Pat

[Anonymous]

@Anonymous  Hey Mate ,As per 80-20 logic .You have show % of total for Pareto .

[mahoneypat · Accepted solution]

You can use the measure expression below for your line value, along with the Event Date on your X-axis (not the hierarchy) to get the shown pic.

Cumul Events =
VAR thisdate =
    MAX ( Sheet1[Event Date] )
RETURN
    CALCULATE (
        [Total Number],
        ALL ( Sheet1[Event Date] ),
        Sheet1[Event Date] <= thisdate
    )

Regards,

Pat

[camargos88]

@Anonymous ,

You can use your event date column without hierarchy:

 

Check the attached file.

[Anonymous]

I was hoping to get something like this

[wdx223_Daniel · Accepted solution]

@Anonymous might this work

Cumulative total = VAR _ym=SUMX(TOPN([Rank],ALL('Sheet1'[Month/Year]),[Total Number],DESC),[Total Number]) VAR _cd=MAX(Sheet1[Event Date]) VAR _d=CALCULATE(COUNT(Sheet1[Event ID]),Sheet1[Event Date]<=_cd) RETURN IF(ISFILTERED(Sheet1[Event Date]),_d,_ym)