Skip to main content

    Power BI

    New

    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 (12) 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 (3)
    's profile image Profile Picture

    8011c2e0 1214-41e6-95fb-bc3dbbeeedc0 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

    164df75a d617-4b9d-9216-5b5158341e1d 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

    f136e1ec c949-4ab1-afaf-e243502a925c 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.