Using Stacked Bar Chart to show Split in Data

[Anonymous]

I am pulling data from a Sharepoint Online list and am having trouble with the Stacked Bar Chart. I had this visual working correctly at one point, but I'm stumped on how to get it working again.

The list contains entries that are sales opportunities. For each entry there is a sales lead and a backup salesperson. I want the chart to show me for each salesperson how many of opportunities they are lead on and how many they are backup on. For example, if person 1 has 30 opportunities, I should see 22 of them as lead and 8 as backup. Currently, the bars are showing 30 as lead and 30 as backup. 

My data fields are as follows:

X-axis:

Sales Lead

Y-axis:

Count of Sales Lead

Count of Backup

Legend:

(Blank)

The table is formatted similar to this: 

Opportunity	Sales Lead	Sales Backup	Status
0001	Person 1	Person 2	Open
0002	Person 3	Person 2	Pending
0003	Person 1	Person 3	Closed
0004	Person 2	Person 1	Closed

Any input would be helpful.  I've tried creating measures and tables...but I'm not the most comfortable with DAX.

[amitchandak · Accepted solution]

@Anonymous ,

Option 1, Unpivot the sales and backup in power query

https://radacad.com/pivot-and-unpivot-with-power-bi

option two: Create common person dimension join with both sales and backup  and create measure with help userelationship for inactive relationship

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970