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.

jaipal's avatar
jaipal
Icon for Resolver III rankResolver III
4 years ago

harshadrokade  I am asuming you looking for the similar solution

 

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