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