Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a bar chart for the values which will switch between a number, a currency and a percentage and I would like for it to show the correct number format based on whats selected.
Also for the Currency I want the "Auto" format but with the currency symbol for example, €12.34M
There is a field used for the switch between Number and Percentage?
Correct, however I want the Number format held within the expression as it needs to change based on the values shown.
Ifyou are switch between number currency and a percentage-->use alternative measure
in the first alternative pass the percentage in the exp asnum(your exp,'######.00%') foramt-->measure exp
in the second alternative pass with currency exp as num(your exp,'########### ###,00 €') and pass the num format as auto.
Measure:
=if(Field='Number', num(expr,'########### ###,00 €'),
num(expr,'######.00%') )
The Percentage format is correct but the currency one doesn't work
Your expression is on the left but i want it to look like the right but with currency symbol.
=if(Field='Number', num(expr,'€ #.##0,00'),
num(expr,'###.00%') )
Check this: