How to create formula label for every barchart

[Pipit]

Hi all,

 I have a barchart that shows comparison amount between Current Year and Last Year for each group. I'd like to change the value label so they will show the percentage ratio between Current vs Last Year instead of the real amount.

Please advise how can I change the value label. 

FYI, I can't use combo chart because it will show the percentage using line (which is not the correct chart to use in this case since I'm not trying to show a trend between groups). Currently there's no way to remove the line, and if I change it to marker, marker point can't show value label.

[Vitali]

Hi there,

have you considered using alternative measure? It's not ideal, but it's very easy to do and it has some advantages.

[Pipit]

Hi,

Thank you for your response. I'm not sure how to apply alternative measure to achieve the result I needed. Can you explain more ?

[Carlos_Reyes]

You can use dual function together with the [Number formatting] property set to "Measure expression". I just tested it using a combo chart... maybe its also doable using a regular bar chart, but will probably require more tricks. Please review the enclosed app.