Quadrant visualization

[andresf]

Hi,

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