Adding % on clustered bar chart

[harshadrokade]

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.

[jaipal]

@harshadrokade  I am asuming you looking for the similar solution

Measure = COUNTA('Table'[Skill])/CALCULATE(COUNTA('Table'[School]), ALLSELECTED('Table'[Skill]))

[amitchandak]

@harshadrokade , Something similar discussed in this video here , check

https://youtu.be/IH4bcHhxunw

[jaipal]

@harshadrokade  are you using measures to show the visuals? if possible share some sample data

[harshadrokade]

Hi @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-zhangti · Accepted solution]

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.