Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
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.
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.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |