Forum Discussion
Solved
Set format to currency and percentage when using SWITCH()
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...
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=asallproducts-allversions#limitationscalculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/
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