Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Using Stacked Bar Chart to show Split in Data

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: 

OpportunitySales LeadSales BackupStatus

0001

Person 1

Person 2Open
0002Person 3Person 2Pending
0003Person 1Person 3Closed
0004Person 2Person 1 Closed


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

1 Reply