Forum Discussion

Soldado's avatar
Soldado
Frequent Visitor
4 years ago

Table matrix

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
Need Help

2 Replies

  • StefanoGrimaldi's avatar
    StefanoGrimaldi
    Resident Rockstar
    4 years ago

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

    calculation: 

    var calculation = DAX YOU HAD

    return formato(calculation, formatcode)

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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