Forum Discussion
hide zero in bar chart
- 18 days ago
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
what i see values are not 0 . those points have some value. if you change Display unit to None in Values section. it will show you original Value. That is is the reason why its appearing.
also if see other CY actual USD, it has actual zero value and its not appearing