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!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hello,
I have a table visual with Customer Names and a measure "Total Sales %" which basically divides the Total Sales with the global Total Sales.
You get something like this:
I would like to group all customers that have <1% of "Total Sales %" in 1 single group called "Others".
How should I tackle this problem?
Kind regards,
Kevin
Solved! Go to Solution.
This is not an easy task in PBI. You can see how such things are done here: https://youtu.be/nVvlEHKr_0o
Great thanks @Anonymous
This will definately help me!
This is not an easy task in PBI. You can see how such things are done here: https://youtu.be/nVvlEHKr_0o
User | Count |
---|---|
11 | |
9 | |
6 | |
5 | |
4 |