How to properly format a number into GB within a matrix

[Jeff2Jets]

I have a matrix that totals sizes for files. I want to display the values in the matrix as K, M, G, or T. However, I cannot locate the option to do this. The best formatting option I can find is what I have highlighted below:

If I choose Thousands or Millions, the value displays as K or M, respectively, as highlighted below:

However, if I choose Billions, instead of showing G, bn displays, as highlighted below:

Ultimately, I would expect Power BI to show K, M, G, or T dependent upon each value. If that isn't possible, does anyone have an idea on how I can have G displayed, instead of bn?

[Jeff2Jets]

Thanks for the help, I don't see any option for Power BI to automatically assign K, M, G, or T for a value in a matrix or for formatting the table column. For instance, if the value is 1024, I want to display 1K. If the value is 1048576, I want to display 1M, etc.

[eliasayyy]

hello 

lets say you have a measure called total amount

create this emsaure to dynamically format 

Dynamic Label = 
SWITCH(
    TRUE(),
    LEN([Total Amount]) <4 , FORMAT([Total Amount],"#,##0"),
    AND(LEN([Total Amount]) >=4 ,LEN([Total Amount]) <7) , FORMAT([Total Amount],"#,##0, K"),
    AND(LEN([Total Amount]) >=7,LEN([Total Amount])<10)   , FORMAT([Total Amount],"#,##0,, M"),
    LEN([Total Amount]) >=10,FORMAT([Total Amount],"#,##0,,, Bn"
    ))

[Idrissshatila]

Hello @Jeff2Jets ,

Try using custom format strings in Power BI https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin