Bar Chart with number and percentage

[giazitzoglou]

Is it possible to have a bar chart and except from the totals to have also the percentage?

Thank you in advance,

Angelos

[dplr-rn · Accepted solution]

Use dual in your expression

e.g.

dual(num(Sum(LineSalesAmount),'#,000.0')& '  (' & num(Sum(LineSalesAmount)/Sum(total LineSalesAmount),'#0.0%')&')',Sum(LineSalesAmount))

so your label will show some thing like 1,200 (10.1%)

Hope it helps

[giazitzoglou]

It works when you change the number formatting to «Measure Expression»

Thanks

[dplr-rn]

No problem. Missed to add that step 🙂