Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Custom number format based on value

    Vote (1) Share
    Jacob Pewitt's profile image

    Jacob Pewitt on 05 Jun 2020 02:28:20

    Please enhance the custom number format option to allow for different formats depending on the value of the number being formatted, like you can do in Excel. For example:

    [>1000000]0.0,," M";#,##0.0

    Which would produce the following formatted results:

    1,232,111 -> 1.2 M
    5,465 -> 5,465.0

    Comments (1)
    Jacob Pewitt's profile image Profile Picture

    Ken Loewen on 10 Jun 2022 21:53:17

    RE: Custom number format based on value

    This is pretty easy to do with Calculation Groups. Check this post out Creating Value Dynamic Formatting using Calculatio... - Microsoft (Web view)