How to dynamically show category members as % of the selected category on x-axis of a Pareto chart

[Soly_Az]

I have created a Pareto chart to show the Cumulative % of Spend for a series of vendors according to the video below:
https://www.youtube.com/watch?v=rlUBO5qoKow

which works fine:

However, as the users previously used to create the chart in Excel, they would like to have "cumulative % of vendors" in the x-axis instead of the vendors; such as the following chart (which is made manually only to illustrate the desired result). In this way the users can interpret the data easier, i.e. "33% of the vendors account for 77% of the total spend".

Any idea if this is possible to do?

Thanks in advance for any suggestions!

[Anonymous]

@Soly_Az 

Basically, you need to create a column to get the cumlative percent of total venders. 

1. Add an index column.

2.  Create a calcuate column 

Column = CALCULATE(COUNTROWS('Table'),FILTER('Table',[Index]<=EARLIER('Table'[Index])))/ COUNTROWS('Table')

Please check my example:

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Soly_Az]

Thanks! However, the use of Earlier and the fact that my vendor-table has 84000+ rows, the formula causes performance issues and won't work.