Hi,
Can someone please help me with this?
I have a raw data like this:
I need to create something like a a BCG matrix/Bubbles diagram (each point would be an employee.) with this characteristics:
1. Top Left hand (Sales contribution >10%, Negative operating margin) :
2. Top Right Hand (Sales Contribution >10%, Positive operating margin) :
3. Bottom left hand (sales contribution <10%, negative operating margin) :
4. Bottom right hand (sales contribution <10%, positive operating margin):
I already upload the Quadrant visualization on Power BI but the legend axis (Trader column) is not allowed.
How can I re arrange my raw data table to do this?
Thanks,
Andres
Can someone please help me with this?
I have a raw data like this:
| Employee | Year | Sales contribution (%) | Operating margin (%) |
| Juan | 2016 | 15% | 12% |
| Juan | 2017 | 26% | 18% |
| Juan | 2018 | 3% | -2% |
| Amber | 2016 | 14% | 7% |
| Amber | 2017 | 1% | 4% |
| Amber | 2018 | 45% | 31% |
| Peter | 2016 | 8% | -5% |
| Peter | 2017 | 9% | -4% |
| Peter | 2018 | 19% | 8% |
I need to create something like a a BCG matrix/Bubbles diagram (each point would be an employee.) with this characteristics:
1. Top Left hand (Sales contribution >10%, Negative operating margin) :
2. Top Right Hand (Sales Contribution >10%, Positive operating margin) :
3. Bottom left hand (sales contribution <10%, negative operating margin) :
4. Bottom right hand (sales contribution <10%, positive operating margin):
I already upload the Quadrant visualization on Power BI but the legend axis (Trader column) is not allowed.
How can I re arrange my raw data table to do this?
Thanks,
Andres
