Gender diversity funnel chart

Question

Hi,&nbsp;I am looking for a pyramid funnel chart which shows both Male &amp; Female data in the same horizontal bar with appropriate split of % or numbers. below is the sample chart &amp; the data table.&nbsp;&nbsp;Table:&nbsp;&nbsp;Employee IDGenderLevel1001Female71002Female81003Male81004Female81005Female71006Male71007Male81008Female71009Male71010Female81011Male8

freemanz · Accepted Answer

hi&nbsp;Vishal7012&nbsp;not sure if i fully get you, tried to make it with standard native stacked bar chart.1) enrich you data as:&nbsp;Level2 = IF([Gender]="Female", -[Level], [Level])&nbsp;&nbsp;2) write two measure like:&nbsp;Female = CALCULATE(SUM(TableName[Level2]), TableName[Gender]="Female")

Male = CALCULATE(SUM(TableName[Level2]), TableName[Gender]="Male")&nbsp;&nbsp;3) plot the measures with department column like this:

Forum Discussion

Gender diversity funnel chart

2 Replies

Related content

Calculation of Gender Diversity

Gender Visual

funnel chart

Help calculating simpson's diversity index

Funnel Comparision

Employee ID	Gender	Level
1001	Female	7
1002	Female	8
1003	Male	8
1004	Female	8
1005	Female	7
1006	Male	7
1007	Male	8
1008	Female	7
1009	Male	7
1010	Female	8
1011	Male	8