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.
I would like to express all the values of my report like in $K,m,bn,... Quite easy in excel with the custom format.
We can create custom column by using DAX but instead of that why cant we get it default in table or matrix itself.
This is as per client request am writing. Thanking You!!
We are currently trying to find a workaround for this format problem.
Maybe someone of you can also help us and the whoule community.
So, we have build a custom table with the entries:
Display normal
Display in k
Display in m
Now we use this Table as a DropDown Menu, to customize the values in the Matrix / Table with this Dax Code via a Measure
Value = IF( ISFILTERED(Formating[Format]);
SWITCH(MAX(Formating[Format]);
// Normal
"Display normal"; VAR ResultNormal = FORMAT([Value];"#,##0")
RETURN if(ResultNormal = BLANK();BLANK();ResultNormal);
// Display in Tausend Formatiere mir den gerundeten Value DAte Wert, welcher durch 1000 geteilt worden ist.
"Display in k"; VAR ResultTausend = FORMAT(ROUND([Value];0);"#,##0,")
RETURN if(ResultTausend = BLANK();BLANK();ResultTausend);
//Display in Million
"Display in m"; VAR ResultMillion = FORMAT([Value];"#,0,,.0")
RETURN if(ResultMillion = BLANK();BLANK();ResultMillion);
//Erster Defaultwert innerhalb des Switch Case
[Value]);
//Defaultwert der IF-Schleife
[Value])
With this Table and our DAX Code, we can transform our Values to our custom format.
Hi, Thank you for quick reply!! I am not looking for currency symbols and my query is like kilo,million,billions,....instead of large numbers(eg:1,000=1k,5,000,000,000=5 bn) i hope you understand
There is no such built-in option for table and matrix visual in current version. We can only workaround it by using DAX.
Please vote on following existing ideas.
Best Regards,
Herbert
is it possible in future?
If this feature is desired by many users and there are many votes, the product team will consider to work on it.
Best Regards,
Herbert
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |