Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Number Formatting: Zeros not to be visible

    Vote (3) Share
    's profile image

    on 30 Oct 2018 04:02:55

    Please introduce a format so that zeros can either not be displayed at all or they can be displayed as a dash. An accounting style format would work. It gets tedious to rely on if statements to return blanks, conditional formatting, or filters. Thanks.

    Comments (1)
    's profile image Profile Picture

    GC G on 13 Aug 2020 13:38:36

    RE: Number Formatting: Zeros not to be visible

    Yes, the ability to set 0 to a "-" would be extremely useful, especially when calculating variances for multiple lines, without using the Format function which can affect Totals.