All retailers data to show in Pareto chart

[Anonymous]

Hi Friends,

I am using "Pareto by sio2graphs" to show distributors who are contributing 80% of total sale but this chart is showing only top 10 distributors and out of top 10 , it is showing who are contributing 80% of sale which is incorrect.

Ideally this chart should show me all the distributors ( around 50 in my data) and then calculate who are contributing 80% of sale.

Please help me how can I do this in Pareto chart. 

[amitchandak]

@Anonymous , I think you looking for 80 Percentile.

Refer these

https://blog.enterprisedna.co/implementing-80-20-logic-in-your-power-bi-analysis/
https://forum.enterprisedna.co/t/testing-the-pareto-principle-80-20-rule-in-power-bi-w-dax/459
https://finance-bi.com/power-bi-pareto-analysis/
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/td-p/763156

[Anonymous · Accepted solution]

Thank you @amitchandak for the quick help as usual.

Let me review these toutorials and implement.