Whale Curve: cumulative revenue by number of Contracts

[codjoMensah]

Hi all,

I've seen similar messages but none got a solution or one that would work for me.

I am trying to get a whale curve like this with the cumulative revenue percentage by number of contracts.

I finally found a way to get a line graph with cumulative revenue percentage (measure) by contracts. 

I faced one principal problem: volumetry. I have around 200 000 contracts. I couldn't show my graph unless I filter on the Top 500 contracts by revenue. I then calculated a new measure for the rank of the contract but I could only show that rank in the tooltip.

What I would like is to have the number of contracts (the rank I calculated) on the abciss instead of the contracts name and be able to keep only some numbers, let's say (1th, 200th, 500th, 1000th, 2000th ...100 000th, 150 000th, 200 000th Contracts) 

I already tried to turn the rank into a calculated column but it didn't work because of the memory ( too many contracts), same happened when I tried to create another table. I can't choose only specific ranks to show in the graph.

Unfortunately, I can't share any data sample as it is confidential.

Thanks 

[lbendlin]

This may help

Pareto Analysis in Power BI - Excelerator BI

[lbendlin]

Have you thought of using a Pareto instead of a whale curve?

[codjoMensah]

Yes I did but I have no idea how to aggregate the number of contracts or build the Pareto. Do you have any idea how? 

Thanks

[codjoMensah]

It's about visualizing contracts profitability by finding out how many contracts help achieve a certain percentage of the total revenue

[lbendlin]

What's the actual business question?  Find the optimal number of contracts for max profit?