Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
get that dax inside a varaible and return it witha format function example:
calculation:
var calculation = DAX YOU HAD
return formato(calculation, formatcode)
Proud to be a Super User!