Multicard - formating number to M , K or B

[Sian1]

Hi, i have a Multicard in Power BI, how can i convert Sales Amount to M or B?

 

[severynm]

The multi-row card does not yet support this functionality yet. See: Display Units Option for Multi Row card.

Depending on how your data is set up, you could create a new measure or column with the properly formatted data (something like this) but it likely will not show up in the multi row card as you expect. I'd suggest using a table instead if you have specific field formatting requirements.

 

[severynm]

Edit: I played around a little more and figured it out. I essentially duplicated the solution I linked above. Create a custom column with the measure:

sales (formatted) = "$" & FORMAT('1178933'[sales],"#,,,.0B")

The drawback is now sales (formatted) column is text, so you cannot perform any further calculations on it. For more information on formatting the formatting strings, here is the documentation: FORMAT function (DAX) - DAX

 

[Sian1]

woo, thanks. I will give it a try