Forum Discussion
BIUser1998
Helper I
Helper IDynamically format billion from bn to B
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. Wh...
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.
vicky_
Super User
Super UserYou 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.
BIUser1998Thank you!