Forum Discussion
Custom Group Chart (simple newbie urgent help!)
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
5 Replies
- andyholl123Regular Visitor
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
- parry2k
Super User
- andyholl123Regular Visitor
Awesome thanks