Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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
Hi @Anonymous,
How to you want to show zero values in a chart? Can you show us an example?
Regards,
Yuliana Gu
something like this:
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
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".
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
145 | |
73 | |
63 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |