Forum Discussion

harshadrokade's avatar
harshadrokade
Icon for Post Partisan rankPost Partisan
4 years ago
Solved

Adding % 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 s...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    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.

harshadrokade's avatar
harshadrokade
Icon for Post Partisan rankPost Partisan
4 years ago

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%

 

 

StandardSkillsSchool
1A1ABC1
2A1ABC1
3A1ABC1
4A1ABC1
5A2ABC1
6A2ABC1
7A2ABC1
8A3ABC1
9A3ABC1
10A3ABC1
11A3ABC1
12A4ABC1
13A4ABC1
14A1ABC2
15A2ABC2
16A2ABC2
17A2ABC2
18A2ABC2
19A3ABC2
20A3ABC2
21A4ABC2
22A4ABC2
23A4ABC2
24A4ABC2
25A4ABC2
26A4ABC2

 

 

 

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

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.