Forum Discussion

cchung3's avatar
cchung3
New Member
3 years ago
Solved

Format Data Labels to Show Total & Percentage

How can I format the data labels on my bar chart to show both the totals and the percentages?

Like this: 8 (7.21%)

Thanks!

Need Help
Tips and Tricks
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi cchung3 ,

    According to your description, here's my solution.

    Sample:

    Creat a measure:

     

    Measure =
SUMX ( ALL ( 'Table' ), 'Table'[Sales] ) & "("
    & FORMAT (
        DIVIDE ( MAX ( 'Table'[Sales] ), SUMX ( ALL ( 'Table' ), 'Table'[Sales] ) ),
        "#.00%"
    ) & ")"

     

    In the visual format pane>Data labels, turn on Costom label and put the measure in Field cell. Get the result:

    I attach my sample below for your reference.

     

    Best regards,

    Community Support Team_yanjiang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies