Calculation of Gender Diversity

[Anonymous]

Hi everyone 🙂 

Here's a question that I've been trying to solve for a while, and I thought I could use your help! 

So I have this table here and I am trying to produce a visual - a stacked column graph for 2 years, which will tell the % of females and males for the respective years. My table looks like this. 

Dept	Location	Worker Type	Gender	Year	Count
HR	UK	Employee	Male	2017	30
HR	UK	Employee	Female	2017	10
HR	UK	Contractor	Male	2017	20
HR	UK	Contractor	Female	2017	20
HR	UK	Employee	Male	2016	20
HR	UK	Employee	Female	2016	10
HR	UK	Contractor	Male	2016	40
HR	UK	Contractor	Female	2016	20
HR	USA	Employee	Male	2017	20
HR	USA	Employee	Female	2017	30
HR	USA	Contractor	Male	2017	15
HR	USA	Contractor	Female	2017	5
HR	USA	Employee	Male	2016	20
HR	USA	Employee	Female	2016	40
HR	USA	Contractor	Male	2016	20
HR	USA	Contractor	Female	2016	10
Finance	India	Employee	Male	2017	10
Finance	India	Employee	Female	2017	10
Finance	India	Contractor	Male	2017	20
Finance	India	Contractor	Female	2017	20
Finance	India	Employee	Male	2016	30
Finance	India	Employee	Female	2016	20
Finance	India	Contractor	Male	2016	10
Finance	India	Contractor	Female	2016	20

I know we need a measure or a calculated column here. Can someone tell me a technique that is easier, less complex and helps me produce the required visual? 

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

You can create a stacked column chart like below:

Best Regards,
Qiuyun Yu