Skip to main content

    Power BI

    New

    Customize the "Display Units property in a visual.

    Vote (92) Share
    Minimon's profile image

    Minimon on 12 Dec 2017 20:44:23

    In visuals, we can use Display Units to format number or currency for example Thousands ("K"), Millions ("M"), Billions ("B").
    In some language or culture these abbreviations are not suitable.
    Instead of (K, M, B) we can change configuration to (M, MM, MMM) or (M, Mn, Md) (K, M, G).
    It will be great to have customization of visual display Units.

    Comments (9)
    Minimon's profile image Profile Picture

    72ee38bd e7e6-4aef-a86e-512832648960 on 06 Jul 2020 00:16:56

    RE: Customize the "Display Units property in a visual.

    All of our other Board reporting displays "millions" as "MM". Disappointing that there is no option to change within the tool.

    Minimon's profile image Profile Picture

    532cea57 0b7b-450c-ab11-0926a55cc126 on 06 Jul 2020 00:10:42

    RE: Customize the "Display Units property in a visual.

    We need custom settings in the Field Formatting section like we have in Excel. I want to summarise my numbers to Thousands but i do not always want to see the "k" after the number. It creates a lot of unnecessary clutter on the visualisation.
    Please make this happen.

    Minimon's profile image Profile Picture

    5277347b f3b6-43d5-bc85-ab05bb0f9b77 on 06 Jul 2020 00:04:50

    RE: Customize the "Display Units property in a visual.

    I totally Agree

    Minimon's profile image Profile Picture

    95f9eda1 dcc2-4b52-b072-9f85cf9d08e7 on 06 Jul 2020 00:04:22

    RE: Customize the "Display Units property in a visual.

    Agreed, when reporting data sizes, would like to change to KB, MB, GB, TB. Even the ability to hide would work.

    Minimon's profile image Profile Picture

    4c6ce100 d92b-418d-afd1-358fde6660a1 on 06 Jul 2020 00:00:42

    RE: Customize the "Display Units property in a visual.

    how come this idea hasn't got more votes..... come on guyyyys...... come on microsoft pleaaaase

    Minimon's profile image Profile Picture

    d47ed9b8 4164-4b6d-85c3-e26caf916637 on 05 Jul 2020 23:45:52

    RE: Customize the "Display Units property in a visual.

    I have a display unit called "Tusinde" in Danish... whats the point of having a display unit, with so many characters??

    Minimon's profile image Profile Picture

    1da80326 68d3-4492-bfb4-770be548cd2a on 05 Jul 2020 23:45:08

    RE: Customize the "Display Units property in a visual.

    An for digital sizes K, M, G, T, P, E is correct.

    Minimon's profile image Profile Picture

    244bd1c5 f155-4ff2-8931-b91726ff6c09 on 05 Jul 2020 23:39:42

    RE: Customize the "Display Units property in a visual.

    I totally agree.
    When creating reports for accountants they want M, MM, MMM instead of K, M, B.
    So the ability to change these abbreviations should be possible to define at the report level, and should overide language settings.

    Creating custom measures doesn't cover all needs, ie. values on Y-axis of charts need to be numbers, not a texts.

    Minimon's profile image Profile Picture

    391198d1 26c2-4b55-8449-accb181a08bd on 05 Jul 2020 23:24:11

    RE: Customize the "Display Units property in a visual.

    Same problem here, in Indonesia
    Miilions are represent as Jt (Juta)
    Bililions are represent as M (Miliar)

    Most people will miss understand M in power bi stands for million, but in Indonesia M stands for Miliar (Billions)

    If we can customize the Display Units, that will be great