Pareto curve modified in graph of grouped columns and lines

[Syndicate_Admin]

Hello everyone

I created the following measure to calculate cumulative sales to show a Pareto curve:

Cumulative sales country =

where Total= [Total sales]

return

SUMX(

filter(

SUMMARIZE(ALLSELECTED(Continents),Continents[Parents],"Venta_acum", [Total sales]),

[Venta_acum]>=Total),[Venta_acum])

Then I calculated it in %.

If I show it on a line chart, the measurement is correct:

But if I use the graph of grouped columns and lines (see next graph), the columns being the sum of sales by country and the line the accumulated sales according to the previous calculation, it is observed that what each point of the line is really representing is the % that each country represents on the total sales. I do not understand this change if the measure is correct. What adjustment would have to be made for the Pareto curve to actually be made in that graph? Thank you.

[Syndicate_Admin · Accepted solution]

Interestingly, with the new formula, the line Y-axis appears as 100% for each of the countries (X axis). In the end I have solved it as follows:
1. The line plot, with the new formula of the accumulated %, I have passed it to column chart

2. I then converted it to grouped column chart with line

3. The Total Sales by Country measure has been put in the Y line example.
4. I have exchanged measures. That is, on the Y axis of columns I have put the total sales and on the Y axis of line I have put the accumulated %, And it has worked!

-

[amitchandak]

@Syndicate_Admin , check if the suggested formula in blog can help

https://exceleratorbi.com.au/pareto-analysis-in-power-bi/