cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## 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

1 ACCEPTED SOLUTION
Microsoft Employee

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] )

Measure =IF ( SUM ( Table[Value] ) = BLANK ()0.00001SUM ( Table[Value] ) )

Remember to specify the End value of Y-axis.

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Microsoft Employee

Hi @Anonymous,

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

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

something like this:

Microsoft Employee

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] )

Measure =IF ( SUM ( Table[Value] ) = BLANK ()0.00001SUM ( Table[Value] ) )

Remember to specify the End value of Y-axis.

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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".

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.