Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
18 days ago
Solved

hide zero in bar chart

i want to hide 0 in bar chart as shown below,  i tried below options but nothing is working removed zero from show blank and put space  make font background white using condition measure_value=0 h...
  • pallavi_r's avatar
    18 days ago

    Hi powerbiexpert22​

    Please try either of these approaches, depending on whether you want to hide the zero labels or the bars.

    1. Replace zero with BLANK()

    Create a new measure:

    Measure_Value_Display =

    IF(

    [Measure_Value] = 0,

    BLANK(),

    [Measure_Value]

    )

    Use this measure in the chart's Values field. Zero-value bars will disappear along with their labels.

    2. Hide only the zero labels

    If you want to keep the bars and hide only the 0.00 labels, create a color measure:

    Label Color =

    IF([Measure_Value] = 0, "#FFFFFF", "#000000")

    Then go to Format visual → Data labels → Color → fx, select Field value, and choose Label Color.

    This makes zero labels white while keeping the other labels black. It works as a workaround on a white chart background.

    For reference, the snapshots below show how the chart looks after applying approaches 1 and 2 using the example above.

    If this post helps, please accept this as a solution. Appreciate your kudos.

    Thanks,

    Pallavi