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 wit...
Need Help
andyholl123's avatar
andyholl123
Regular Visitor
8 years ago

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's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

see attached, sheet 7 and table 7 to produce the desired result

  • andyholl123's avatar
    andyholl123
    Regular Visitor
    8 years ago

    Awesome thanks

  • andyholl123's avatar
    andyholl123
    Regular Visitor
    8 years ago

    Hi, try as I might, I am unable to reverse engineer your solution  :smileyindifferent:

     

    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

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      8 years ago

      I added a new column called "customer group" and that is what you need.