Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |