Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi, I have a chart that has too many products on the legend so I wanted to show only the products with the most sales and the rest named "others". Do you know how can achieve this?
I build a table with product and sales and create this measure but I know that is wrong because the TOPN is a table and not a column but I don't know how to fix it. Can you please help?
| product | sales |
| A | 100 |
| B | 200 |
| C | 400 |
| D | 50 |
| E | 74 |
| F | 300 |
| G | 56 |
| H | 53 |
| I | 21 |
| J | 80 |
| K | 150 |
@marijane , refer topn with others
Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 55 | |
| 49 | |
| 33 | |
| 16 | |
| 15 |
| User | Count |
|---|---|
| 85 | |
| 70 | |
| 38 | |
| 28 | |
| 25 |