Forum Discussion
power Bi CARD
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.
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
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