Percentages for group clustered columns

[PowerBINoob24]

Good evening,

Hopefully I can explain this clearly.  I've been banging my head against the wall all day.

I'm trying to create a clustered column chart with groups.  When I try to show percentages it will break out the percentages across all of the groups, but I need it to do the percentage based upon each group.  Enrolled, Attended, and NoSHOW are the columns that are grouped by CourseName.  HOw can I get the column to break out the percentages based upon the total number of coursename?  Basically the first group: enrolled / total of CourseName1, attended / total of CourseName1, noshow / total of CourseName1.  And then for the second group enrolled / total of CourseName2, attended / total of CourseName2, noshow / total of CourseName2

Hopefully I made that somewhat clear.

EMAIL	Enrolled	Attended	NOSHOW	CourseName
Email@somewhere.com1	1	1	0	Azure101
Email@somewhere.com2	1	1	0	Azure101
Email@somewhere.com3	1	1	0	Azure101
Email@somewhere.com4	1	1	0	Azure101
Email@somewhere.com5	1	1	0	Azure101
Email@somewhere.com6	1	0	1	Azure101
Email@somewhere.com7	1	0	1	Azure900
Email@somewhere.com8	1	0	1	Azure900
Email@somewhere.com9	0	0	0	Azure900
Email@somewhere.com10	0	0	0	Azure900
Email@somewhere.com11	1	1	0	Azure900
Email@somewhere.com12	1	0	1	Azure900
Email@somewhere.com13	1	1	0	Azure900

[PowerBINoob24]

Thanks!  That's perfect!

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your desired outcome of a visualization looks like, but please check the below picture and the attached pbix file.