Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 38 | |
| 36 | |
| 28 | |
| 28 |
| User | Count |
|---|---|
| 124 | |
| 89 | |
| 73 | |
| 66 | |
| 65 |