Accumulate customers on x axis in customer whale curve

[Anonymous]

Hi all, 

I am making an analysis of aggregated revenue for our customers from the largest to the smallest customers. As we have a couple of thousand customers, the x axis should not display the customer names, but the aggregated number of customers. The first picture shows what the graph should look like. However, when I make it in PowerBi, the graph becomes too big, as the X axis displays over 3.000 customers. Is there any way to fix this in PowerBI? 

[codjoMensah]

Hi @Anonymous ,

I am currently trying to build a whale curve just like you with cumulative Revenue and number of contracts. Were you able to achieve the graph you wanted? I've tried many solutions without success and your post really sums up what I want. i'll be grateful if you could send me your calculations and the way you did it.

Thanks 

[v-frfei-msft]

Hi @Anonymous ,

Please try to create a calculated column as below and add it to X-Axis.

count = calculate (countrows(your table),filter(your table, your table[customer] = earlieryour table[customer]))

If it doesn't meet your requirement,  kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive for Business and share the link here.

[Anonymous]

Hi,

Thank you very much for your reply. I succeded in making the calculated column that gives each customer a unique ID ( my problem was that each customer had maybe 1000+ rows in my table and I didn't know how to tell PowerBi to give unique ID based on customer and not each row).

I have also changed the measures to rank by the calculated column instead. However, now my graph looks like this:

If I change it to a waterfall chart it sorts correctly, by the customer who has the biggest portion of revenue. However, I still need to be able to group them, so the graph doesn't become so long. Any suggestions on how to do that?

[amitchandak]

Try to use customer id on x-axis .

If do not have customer id create one using - https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-query