power Bi CARD

[vjnvinod]

hi,

How do we format Power BI card visuals to Millions or billions based on our requirment.

I don't find any option to do so.

Please suggest if there is a way to do it.

[mikez2605]

Under formatting for the card, try changing the Display Units field (under Data Label)?

Before:

After:

[vjnvinod]

@mikez2605

No Display option showing in power BI desktop. see my scrubbed file below, can you try?

https://www.dropbox.com/s/9j5asfq7xpdt0go/testchecknew.pbix?dl=0

[mikez2605]

I see you're using a multi row card, whereas I was using a card, which explains the difference. Looks like that formatting option isn't available for multi row cards. I would recommend creating 6 different cards and set the format individually.

Otherwise, you could create a measure similar to the below:

"=CONCATENATE(TRUNC([value name])/1000000,2),"M")" (for millions)

You'd have to do this for each data point however, so it's not an ideal solution