Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Gauges should display "N/A" or "No Data", not 0.

    Vote (3) Share
    Power BI Ideas Admin's profile image

    Power BI Ideas Admin on 19 Sep 2015 01:47:28

    If the difference between a zero value and a null value matters to your analysis, there is no way to display this on Gauges. If no data is available, it defaults to zero. It should default to N/A!

    Comments (1)
    Power BI Ideas Admin's profile image Profile Picture

    Power BI Ideas Admin on 05 Jul 2020 22:05:14

    RE: Gauges should display "N/A" or "No Data", not 0.

    Found a workaround. If you do if([value]=blank () ,(1/0),[value]) , you can force an infinity value! This isn't ideal, but it gets the job done.