pareto chart (problem with ties and measures)

[corodyne]

All,

I will admit defeat.  I have tried many, many iterations of a Pareto chart with my data set, but have hit a brick wall.

Issue:  I have data that results in ties (same number figure when ranking using a measure).  I have found no workable way around this.  Hoping you can help.  (any working link to a solution or file would be most appreciated)

Key requirement:  The cumlative sum and pareto calculations must be measures. I am NOT using date values to try and rank or sum over time.

Data:  The data is formatted as below in a Chart.  The Chart is created using slicers from over a 1M rows of data and the Sales are aggregate sales figures for each item.  The problem arises when trying to do a cumalitve sum and ranking for pareto values as there is a tie between items B and C.

Item	Sales
A	10
B	9
C	9
D	7
E	3

[v-jiascu-msft]

Hi @corodyne,

Could you please mark the proper answer as solution or share the answer if it's convenient for you? That will be a help to the others.

Best Regards!
Dale

[Vvelarde]

@corodyne

Hi, Maybe this can help you.

https://www.pbiusergroup.com/blogs/victor-velarde/2017/07/07/como-realizar-un-diagrama-8020-o-de-dis...

In is spanish, but with a translator you can follow it.

Regards

Victor

Lima - ¨Peru

[Jancarlos_Ascen]

Encontre la solución con ello

[corodyne]

Here is a  quick snapshot of the row ranking problem (which has a tumble down effect for cumulative sums and pareto calculations) -- See all the Spend Rank 192 values??