Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. 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
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
68 | |
67 | |
41 | |
39 |
User | Count |
---|---|
48 | |
43 | |
29 | |
28 | |
27 |