Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Have a table with customer name and total.
I would like to have them in a pie chart with top 10, and one slice as other for the reamianing.
Also I would like to have a matrix or table showing rank and % of total for all
Thank you
Customer | Total |
Murphy Oil | 2,212.00 |
XTO Energy | 21,254.00 |
Cenovus FCCL Ltd. | 887,546.00 |
Athabasca Oil Corporation | 6,558.00 |
Rifle Shot Oil Corp. | 5,423.00 |
MEG Energy Corp. | 3,997.00 |
Crescent Point Energy Corp. | 88123 |
Nexen | 12,354.00 |
Shell Canada Ltd. | 21,665.00 |
Keyera Energy | 54,884.00 |
Arc Resources Ltd. | 269,853.00 |
Paramount Resources Ltd | 249,989.00 |
Husky Energy Inc. | 21,868.00 |
Dienarian Resources Inc. | 9,899.00 |
Serafina Energy Partnership | 9,335.00 |
Tourmaline Oil Corp. | 2,599.00 |
TransGas | 5,668.00 |
Solved! Go to Solution.
One way could be to add a calculated column in your Table
Top 10 Customers = IF ( [Total] IN TOPN ( 10, VALUES ( Table1[Total] ), [Total], DESC ), [Customer], "Others" )
Now you can use this column in Pie Chart
One way could be to add a calculated column in your Table
Top 10 Customers = IF ( [Total] IN TOPN ( 10, VALUES ( Table1[Total] ), [Total], DESC ), [Customer], "Others" )
Now you can use this column in Pie Chart
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |