Set format to currency and percentage when using SWITCH()

[markandrewolive]

I have a report with a slicer that changes the metric being displayed so that, for each category, our client can switch between viewing the percentage of respondents or their projected annual revenue impact

When I use data labels, the project annual revenue impact looks exactly how I want it to:

The number is condensed to "16M" and easy to read.

However, when I use "Total Data Labels", the number does not get condensed:

Which can make it a bit messy and hard to read.

Normally, I'd fix this by changing the metric, but, in this case, my metric can be either a percentage or a dollar value.

Is there any way to standardize how a metric is displayed when it is a calculated measure using SWITCH()?

[v-shex-msft]

Hi @markandrewolive,

Did the above suggestion help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements.

Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@markandrewolive , when you use to switch it has that problem. For that calculation group using tabular editor is an alternate, there you can different format for each number 

tabular - Calculation groups
https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallprodu...

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/