Hi, I am v new to Power BI, most grateful for help with the following query.
I would like a view of data which looks like the attached image, which is basically a custom grouping of Companies with number of customers with low customers (640 or below) medium no of customers (640 to 740 suppliers) and high number of suppliers, (740 or above)
My Data Set is a simple .csv / excel file as below.
It seems a simple query, but I just can't work out how to do it optimally... any advice gratefully received. I can do it in Excel but need to create custom calculations which is sub-optimal
Company Name | Number of Customers |
Company1 | 480 |
Company2 | 450 |
Company3 | 800 |
Company4 | 600 |
Company5 | 630 |
Company6 | 750 |
Company7 | 790 |
Company8 | 720 |
Company9 | 550 |
Company10 | 770 |
Company11 | 710 |
Company12 | 540 |
Company13 | 620 |
Company14 | 750 |
Company15 | 540 |
Company16 | 800 |
Company17 | 670 |
Company18 | 670 |
Company19 | 700 |
see attached, sheet 7 and table 7 to produce the desired result
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Any ideas please guys / gals?
First time user of PowerBI and I thought this would be a really simple query?
Here is the chart I managed in Excel, which I wish to produce in PowerBI?
Many thanks
see attached, sheet 7 and table 7 to produce the desired result
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi, try as I might, I am unable to reverse engineer your solution 
Please could you give me a very brief overview of how you did it please? How do I create the Company Group? I've tried new query or new measure / new parameter etc?
Many thanks
I added a new column called "customer group" and that is what you need.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
