I would like to express all the values of my repport like k,m,bn,...

[vuyala]

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!! 

Spoiler

[Anonymous]

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.

[v-haibl-msft]

@vuyala

Format is also availabe in Power BI Desktop as following screenshot.

Best Regards,
Herbert

[vuyala]

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

[v-haibl-msft]

@vuyala

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.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13760049-customize-values-in-matr...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31655710-support-for-display-unit...

Best Regards,
Herbert

[vuyala]

is it possible in future?

[v-haibl-msft]

@vuyala

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