Formatting a switch function

[rbruce545]

I currently have the following which allows a user to select the measure to plot:

METRIC = if(ISFILTERED('KPI_DAX'[VARIABLE_LABEL]),SWITCH(SELECTEDVALUE('KPI_DAX'[VARIABLE_LABEL]), "Accepts",[Accepts] ... (followed by several other metrics) ... ) , 0 )

However I would like some of the measures to be formatted as percentages, some as currency and some as numbers - is there a way to change the individual format of measures within the switch function?

[Anonymous]

@rbruce545  - I don't think you can have a single measure with multiple formats.

One potential solution is to have 2 measures: One unformatted, to use in charts, and another formatted as text so that you can show the various formats.

Hope this helps,

Nathan