Forum Discussion

Vishal7012's avatar
Vishal7012
Regular Visitor
3 years ago
Solved

Gender diversity funnel chart

Hi,   I am looking for a pyramid funnel chart which shows both Male & Female data in the same horizontal bar with appropriate split of % or numbers. below is the sample chart & the data table.   ...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Vishal7012 

    not sure if i fully get you, tried to make it with standard native stacked bar chart.

    1) enrich you data as:

     

    Level2 = IF([Gender]="Female", -[Level], [Level])

     

     

    2) write two measure like:

     

    Female = CALCULATE(SUM(TableName[Level2]), TableName[Gender]="Female")

Male = CALCULATE(SUM(TableName[Level2]), TableName[Gender]="Male")

     

     

    3) plot the measures with department column like this: