Dynamically format billion from bn to B

[BIUser1998]

Hello all,

I have created a measure in PowerBI which is displayed on a KPI Card. I have kept the data type as Currency as its financial data and have kept the units option on Auto on the card. When the value is in millions, the card displays the value as $1.23M but when the value reaches billions, it shows it as $1.23bn instead of $1.23B. Is there any way to show the value with the capital B dynamically without converting the value to text?

Any help would be really appreciated. Thank you

[vicky_ · Accepted solution]

You can use dynamic format strings: 

https://www.sqlbi.com/articles/introducing-dynamic-format-strings-for-dax-measures/

You can almost copy the section in the Format String Expression for Sales Amount measure in Sales table section, but just add another row with the condition for B.

[BIUser1998]

Thank you!