Percent of Column Total in a Clustered Bar Chart

[Anonymous]

Hello,

I have a clustered bar chart that shows the count of "Level" by "Analyst" with the count of "Level" displayed on each bar. Below that, I would like to have the same clustered bar chart that displays the percent of column total. So for analyst B, 4 would be displayed as a percentage of 7 (57%), the column total. Is there a way to achieve this other than having the percent of column total displayed as a matrix?

[parry2k · Accepted solution]

@Anonymous  you need to add following measures to get this and change % modelling to "percentage", now you can use this % on clustered chart instead of level count.

Level Count = COUNT( Table[Level])

Total Level by QA Analyst = 

CALCULATE( [Level Count], ALLSELECTED(Table[QC Analyst]))

% = DIVIDE( [Level Count], [Total Level by QA Analyst])

[aebbage]

Hi,  

New to PBi here.  I was wondering if you could give me a hand with my data. 

I have tried out your solution to the above for my data,  however it appears to be calculating the percentage based on the sum of the individual response (e.g. strongly disagree across all attributes) rather than the subtotal of the attribute response cluster.  I'm just not sure what I need to change here to get it to work.   

Also, the rounding doesn't seem to be working correctly, as some equal 100 but others 99 and 100. Is there a way to fix that too?

Thanks

AE