Number format by expression

[ksharpes]

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

[Claudiu_Anghelescu]

There is a field used for the switch between Number and Percentage?

[ksharpes]

Correct, however I want the Number format held within the expression as it needs to change based on the values shown.

[manoranjan_d]

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.

[Claudiu_Anghelescu]

Measure:

=if(Field='Number',  num(expr,'########### ###,00  €'),

num(expr,'######.00%') )

[ksharpes]

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.

[Claudiu_Anghelescu]

=if(Field='Number', num(expr,'€ #.##0,00'),

num(expr,'###.00%') )

[Claudiu_Anghelescu]

Check this: