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.
BIUser1998Helper I
Helper IThank you!