Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Under formatting for the card, try changing the Display Units field (under Data Label)?
Before:
After:
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |