Trying to create bar chart with percentages

[mbrierley]

I'm trying to create a bar chart (similar that shown above) that shows the percentage for grades in my organisation. I then need each bar for each grade to be subdivided to show the results for religion. So for example, for EO grade, I need to see the percentages for 'christian', 'muslim', 'hindu' etc. But I also need to hide data from view, such as 'prefer not to say' without affecting the percentages. 

I'm stuggling to show this at the moment and was hoping someone could advise? I'm fairly new to Power BI so don't have a great knowledge of it

[V-lianl-msft · Accepted solution]

Hi @mbrierley ,

First, you can create a calculated column to get the value of each grade.

Then use the if function to return the value of each religion and divide it by the calculated column.

Please refer to the pbix.

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

[mbrierley]

That's great! I had to do a little bit of custom editing of the forumulas but I got there in the end. I also found the link below pretty helpful too;

click here 

[Tahreem24]

Use clustered column chart from Visualization pane.

Please give Kudos and accept this as a solution if it helps you.

[mbrierley]

I've tried this but I when I moved the field with the religion results into the value field, it doesn't split the data up. It just pulls back one block. Is there something obvious that I'm missing 😕

Also, the data field that I'm using is a text field and I can't seem to change to %. The axis is therefore still showing headcount