calculate percentage by category

[Ksp95]

HI i am having a dataset with grades of all the students and i need them as percentage by gender that is male or female.

The problem is when i am plotting the graphs seperately, each graph is individually summing their columns to 100%.

But when combined into a single stacked column chart the filters are working on the visual and disrupting the graph.

below is the sample dataset:

When the above two category graphs are combine i need them to stay as they are without interacting with each other.

Any suggestions and help will be really appreciated.

Thanks,

Sai

[v-rzhou-msft · Accepted solution]

Hi @Ksp95 ,

I suggest you to try Cluster column chart instead of Stacked column chart to combine two visuals.

You can create a visual by Cluster column chart as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Ksp95 , You can create a measure like

Divide( Sum(Table[Value]), Calculate(Sum(Table[Value]), removefilters(Table[gender])) )