Convert axis to percent using dual-function

[StefanFHDO]

Hello Everyone

I'm stuck with my x-axis not showing percent values in bar chart.

I'm currently using a dual-function in my bar chart for percent values and absolut values in brackets. My axis is 0 - 1 instead of 0% -to 100%. I would like to change the axis.

Here are my lines of code.

dual(Num(Sum(AG)/Sum(G), '#,##%')&' ('&Sum(AG) & ')',Sum(AG)/Sum(G))

Without dual function it works as intended by changing settings: number format -> auto. While using dual function i set my number format to measure formula. Any suggestions? 

Thanks.