Skip to main content

Power BI

Needs Votes

Having rounding to millions showing as M and billions showing as bn, then trillions showing as T does not makes sense. Billions s/b B

Vote (19) Share
's profile image

on 11 Aug 2017 00:50:19

I am building a corporate dashboard and have an exec summary along with graphs that have data in either billions or millions. Millions shows up as 200.2M but billions shows up as 1.2bn. It should be 1.2B

Comments (4)
's profile image Profile Picture

Peter Godzina on 07 Mar 2023 21:40:08

RE: Having rounding to millions showing as M and billions showing as bn, then trillions showing as T does not makes sense. Billions s/b B

100K1M1bn1TWhich one is not like the others?? Every single director, VP, and everyone in between at my company is chewing my ear off about this. Give us the capital B please!! It's the proper notation in finance!

's profile image Profile Picture

Power BI User on 16 Aug 2020 04:11:43

RE: Having rounding to millions showing as M and billions showing as bn, then trillions showing as T does not makes sense. Billions s/b B

1.2 billions should be displayed as 1.2G (as in giga)

's profile image Profile Picture

Jeff Brown on 16 Aug 2020 04:08:52

RE: Having rounding to millions showing as M and billions showing as bn, then trillions showing as T does not makes sense. Billions s/b B

Simple change that would make the product show better to picky end users.

's profile image Profile Picture

Cathleen F. Crowley on 16 Aug 2020 04:07:20

RE: Having rounding to millions showing as M and billions showing as bn, then trillions showing as T does not makes sense. Billions s/b B

I agree. I need to follow AP style for abbreviating numbers and the AP style is B for billions. At the very least, it would be nice to have the option to customize abbreviations.