Hi,
I have created the following measure:
if (Getfieldselections(Sales_type)='Percent',num(sum(per_sales)/100,'#,##0%' ),Num(sum(sales),'#,##0'))
If the user select the option 'Percent' - the measure display as percent else as number..
Also I want that the format of the Y axis will change accordingly. (if the user select 'Percent' it will display with percent format else number)
Is this possible?
Thank you!