bar chart suggestion to show zero values

[Anonymous]

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

[v-yulgu-msft]

Hi @Anonymous,

How to you want to show zero values in a chart? Can you show us an example?

Regards,

Yuliana Gu

[Anonymous]

something like this:

[v-yulgu-msft · Accepted solution]

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

[kymramosrpo]

Thank you for that work-around on this! Was also wondering how could I show data with zero values because I want a complete 12-month x-axis reference.

If in case no one has shared this yet, the formula would also work if you entered the value "0" instead of "0.0001". I noticed that if you did this, then the data label would show "0" instead of "1.0-E".