Forum Discussion
bar chart suggestion to show zero values
Hi,
I am trying to display category wise price trend over time, I have two distinct categories for which price can be zero: one when the product is unavailable, second when the product is none (don't bother about the logic behind it). Right now i don't have a way to distinguish between these two categories in the column chart, what do you guys suggest I do?
Thank
Hi Anonymous,
The circled values in Oct, Nov and Dec is zero, right? I'm afraid the chart visual in Power BI cannot display zero value like this.
As a workaround, you can show 0.000001 which approximately equals to 0 in a chart. For example, if your original measure is like: Measure =SUM ( Table[Value] )
Please modify it to:
Measure =IF ( SUM ( Table[Value] ) = BLANK (), 0.00001, SUM ( Table[Value] ) )
Remember to specify the End value of Y-axis.
Best regards,
Yuliana Gu
4 Replies
v-yulgu-msftMicrosoft Employee
Hi Anonymous,
How to you want to show zero values in a chart? Can you show us an example?
Regards,
Yuliana Gu
- v-yulgu-msft
Hi Anonymous,
The circled values in Oct, Nov and Dec is zero, right? I'm afraid the chart visual in Power BI cannot display zero value like this.
As a workaround, you can show 0.000001 which approximately equals to 0 in a chart. For example, if your original measure is like: Measure =SUM ( Table[Value] )
Please modify it to:
Measure =IF ( SUM ( Table[Value] ) = BLANK (), 0.00001, SUM ( Table[Value] ) )
Remember to specify the End value of Y-axis.
Best regards,
Yuliana Gu