Table matrix

[Soldado]

Hello Community

Is there a way to keep the format of the values in a table matrix although the formats are different?

For instance, i have a table in excel with a list of KPI's with its corresponding value. Some of the KPI's are numbers (double with decimals) and other are percentage (%). 

How can the KPI;s be visualized in the table matrix keeping the format? 

I tried to do it with function "SWITCH" linked to a slicer, however when all the options in the slicer are unchecked, the table shows all the values as numbers (whole number), % and decimals got removed.

this is the code i am using

Calculation = SWITCH(

TRUE(),

[User selection]="DSO (days)",[KPIaverage] / 1000,

[User selection]="Short payments >60d (%)",format([KPIaverage],"percent"),

[User selection]="Short payments >60d ($K)",FORMAT([KPIsum],"Standard"),

[User selection]="Net Sales",FORMAT([KPIsum] ,"Standard"),

[User selection]="Debit AR > 60d ($K)",FORMAT([KPIsum],"Standard"),

[User selection]="Debit AR > 60d (%)",format([KPIaverage],"percent"),

[User selection]="Invoices Current (%)",format([KPIaverage],"percent"),

([KPIsum]

))

i appreciate your help

[Anonymous]

HI @Soldado,

AFAIK, the current one field does not support display/return multiple formats. You can use the format function to custom the output format but it will also convert the data type to the text.
Regards,

Xiaoxin Sheng

[StefanoGrimaldi]

get that dax inside a varaible and return it witha  format function example: 

calculation: 

var calculation = DAX YOU HAD

return formato(calculation, formatcode)