Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello!
I have a dataset that consists of 3 columns (Customer_name, Sum of sales, Count of purchases). I'm trying to create a whale curve with percentages of customers on x-axis from most contributing customers to sales and number of purchases to least contributors.
On y-axis I'd like to have two measures(lines) % of running total of sum of sales and % of running total of count of purchases.
I'm more of a Tableau user, and this grapf can be reached by this method Discover the Winners and Losers within your Customers using a Whale Curve! (biztory.com)
How can achieve this in Power BI? Could you help?
Here's the table I'm using.
Customer Name | Sum of SALES | Count of Purchases |
customer 1 | $1,444,864 | 919 |
customer 7 | $651,757 | 51 |
customer 9 | $478,615 | 4732 |
customer 11 | $429,033 | 469 |
customer 12 | $423,352 | 2104 |
customer 16 | $341,529 | 997 |
customer 17 | $339,345 | 232 |
customer 19 | $320,151 | 52 |
customer 20 | $317,674 | 5191 |
customer 22 | $288,621 | 643 |
customer 26 | $252,856 | 7981 |
customer 31 | $219,754 | 2677 |
customer 32 | $215,604 | 9611 |
customer 33 | $194,254 | 4555 |
customer 34 | $193,653 | 265 |
customer 36 | $186,309 | 453 |
customer 37 | $184,392 | 40 |
customer 38 | $184,034 | 138 |
customer 39 | $182,664 | 4013 |
customer 42 | $169,678 | 36 |
customer 43 | $165,958 | 1090 |
customer 44 | $165,688 | 43673 |
customer 46 | $157,895 | 2136 |
customer 52 | $133,460 | 509 |
customer 53 | $131,021 | 62 |
customer 54 | $123,378 | 127 |
customer 55 | $122,637 | 2489 |
customer 57 | $119,474 | 52 |
customer 59 | $114,697 | 545 |
customer 62 | $112,642 | 5339 |
customer 65 | $109,094 | 190 |
customer 66 | $108,207 | 262 |
customer 67 | $107,928 | 5679 |
customer 69 | $107,287 | 7903 |
customer 74 | $100,475 | 28 |
customer 78 | $93,545 | 850 |
customer 79 | $92,961 | 9410 |
customer 80 | $92,785 | 3 |
customer 81 | $92,775 | 3 |
customer 82 | $92,537 | 8240 |
customer 83 | $92,402 | 3569 |
customer 84 | $91,547 | 124 |
customer 85 | $91,062 | 931 |
customer 86 | $90,353 | 110 |
customer 87 | $90,238 | 110 |
customer 90 | $88,389 | 275 |
customer 93 | $86,336 | 9 |
customer 95 | $84,116 | 7176 |
customer 101 | $77,855 | 46 |
customer 102 | $75,779 | 7138 |
customer 107 | $70,745 | 5164 |
customer 109 | $69,375 | 18511 |
customer 110 | $69,256 | 2576 |
customer 111 | $67,947 | 1898 |
customer 116 | $65,519 | 3870 |
customer 118 | $64,084 | 1256 |
customer 119 | $63,712 | 621 |
customer 120 | $63,080 | 85 |
customer 121 | $62,773 | 391 |
customer 122 | $62,580 | 27434 |
Solved! Go to Solution.
a whale curve with percentages of customers on x-axis from most contributing customers to sales and number of purchases to least contributors.
On y-axis I'd like to have two measures(lines) % of running total of sum of sales and % of running total of count of purchases.
How is that a whale curve? Sounds more like two independent histograms.
Visualizing customer profitability with the whale curve - Baker Tilly
Maybe this is closer to what you want?
It plots the cumulative percentage of sales versus the cumulative percentage of contributing customers.
You would need customers with negative sales to get a whale curve.
a whale curve with percentages of customers on x-axis from most contributing customers to sales and number of purchases to least contributors.
On y-axis I'd like to have two measures(lines) % of running total of sum of sales and % of running total of count of purchases.
How is that a whale curve? Sounds more like two independent histograms.
Visualizing customer profitability with the whale curve - Baker Tilly
Maybe this is closer to what you want?
It plots the cumulative percentage of sales versus the cumulative percentage of contributing customers.
You would need customers with negative sales to get a whale curve.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
83 | |
65 | |
49 |
User | Count |
---|---|
127 | |
108 | |
89 | |
70 | |
66 |