Hi everyone,
I have a number of different combo charts and would like the measure to appear in the pop-up formatted to one decimal place, but would like the y-axis to display integers. I have been able to achieve this for a grouped bar as in the screen shot below by using Num(x,'##0 0%') in the measure and setting the format of the measure to Auto:
However, the same approach does not work on the stacked bar:
Does anyone know whether this can be done? Ideally, we would have a format property in the Appearance/y-axis panel, but there is not one.
Thanks in advance,
Richard