Forum Discussion
Post PartisanAdding % on clustered bar chart
Hi,
I have clustered bar chart as below. I want to show % instead of number on this visual. If I use 'Show as %' option in values tab, it shows % of all blue & grey counts as a whole. I want to show break of blue bars in % seperately which will tally to 100%. Similarly the greys individual % should tally to 100%.
Plssssss help me know how to achive the same.
Hi, harshadrokade
Please check the following methods.
Measure = VAR N1 = CALCULATE ( SUM ( 'Table'[Standard] ), FILTER ( ALL ( 'Table' ), [School] = MAX ( 'Table'[School] ) && [Skills] = MAX ( 'Table'[Skills] ) ) ) VAR N2 = CALCULATE ( SUM ( 'Table'[Standard] ), FILTER ( ALL ( 'Table' ), [School] = MAX ( 'Table'[School] ) ) ) RETURN DIVIDE ( N1, N2 )Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
jaipalResolver III
harshadrokade are you using measures to show the visuals? if possible share some sample data
harshadrokadeHi jaipal,
Pls see below data. I have also created the visual for your referance but it is not showing %. I want tio show % that will tally to 100% seperately for School ABC1 & School ABC2. Light Blue total % wil sum up 100 & dark blue will also sum up 100%
Standard Skills School 1 A1 ABC1 2 A1 ABC1 3 A1 ABC1 4 A1 ABC1 5 A2 ABC1 6 A2 ABC1 7 A2 ABC1 8 A3 ABC1 9 A3 ABC1 10 A3 ABC1 11 A3 ABC1 12 A4 ABC1 13 A4 ABC1 14 A1 ABC2 15 A2 ABC2 16 A2 ABC2 17 A2 ABC2 18 A2 ABC2 19 A3 ABC2 20 A3 ABC2 21 A4 ABC2 22 A4 ABC2 23 A4 ABC2 24 A4 ABC2 25 A4 ABC2 26 A4 ABC2 
v-zhangtiCommunity Support
Hi, harshadrokade
Please check the following methods.
Measure = VAR N1 = CALCULATE ( SUM ( 'Table'[Standard] ), FILTER ( ALL ( 'Table' ), [School] = MAX ( 'Table'[School] ) && [Skills] = MAX ( 'Table'[Skills] ) ) ) VAR N2 = CALCULATE ( SUM ( 'Table'[Standard] ), FILTER ( ALL ( 'Table' ), [School] = MAX ( 'Table'[School] ) ) ) RETURN DIVIDE ( N1, N2 )Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- amitchandak
Super User
harshadrokade , Something similar discussed in this video here , check
- jaipal
harshadrokade I am asuming you looking for the similar solution
Measure = COUNTA('Table'[Skill])/CALCULATE(COUNTA('Table'[School]), ALLSELECTED('Table'[Skill]))
