cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gerasimovav Regular Visitor
Regular Visitor

Showing zero values in line chart

Hello colleagues!

This is a very popular theme as I see. But I haven't found solution to my case yet. 

So, I have this measure and line chart:

ship1.png

 

There is zero value on 1 May, but, as you can see, zero point is skipped in the line chart.

If I add +0 to the measure I will get:

ship2.png

Zero value on 1 May has appeared, but a lot of fake zero values (there are no zero values but all of them filtered by slicer) have appeared too. The line chart is getting to be inconvenient.

 

 

 

 

5 REPLIES 5
Super User
Super User

Re: Showing zero values in line chart

What is your measure formula? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Community Support Team
Community Support Team

Re: Showing zero values in line chart

Hi @gerasimovav,

Could you please share some sample data to have a test if possible?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gerasimovav Regular Visitor
Regular Visitor

Re: Showing zero values in line chart

Hello, @v-danhe-msft

It's quite easy. For example the measue is 

Number of Orders = COUNTROWS(SENDING) 

Where table "Sending" looks like

 pi1.png

As you can see there are no rows with 01.05.2018 PO_CREATION

I put a slicer by PO_CREATION and filter by PO_CREATION beetwean 30.04 and 03.05:

pi2.png

As you can see there is no zero point point at 1 May. Line goes from 30 April directly to 2 May. 

I need zero point in 1 May!

Now I change the measure to 

Number of Orders = COUNTROWS(SENDING)+1 

And get:

pi3.png

Zero point apeared but with a lot of fake zero data

Community Support Team
Community Support Team

Re: Showing zero values in line chart

Hi @gerasimovav,

Based on my test, there is no record in the 2018/5/1, if you want to show 0 in 2018/5/1, it should have a row of 2018/5/1:

1.PNG

If your data do not contain the reocord in 2018/5/1, the visual will show by design and will not show a zero.

 

Regards,

Daniel He

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

Re: Showing zero values in line chart

Hi,

 

Share the link from where i can download your PBI file.