Show both number & percentage in value labels for the charts.

[sudheersakamuri]

Dear Team,

I want to show both number and percentage in bar chart value lable like below screenshot.

I am using below expression but  it's not working.

dual(Count (DISTINCT([ID])) & chr(13) & '(' & num((Count (DISTINCT([ID])))/(Count (total [ID])),'##.0%') & ')', Count (DISTINCT([ID])))

Kindly Let me know if I am doing anything wrong ?

[MayilVahanan]

Hi

Try to set the the Expression formatting as "Measure expression" instead of Default

[sudheersakamuri · Accepted solution]

Ahhhh I missed it  😊 Thank You @MayilVahanan 

It's working now !!