Forum Discussion

andyholl123's avatar
andyholl123
Regular Visitor
8 years ago
Solved

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

 

 

5 Replies

  • andyholl123's avatar
    andyholl123
    Regular 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