Showing zero values in line chart

[gerasimovav]

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:

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:

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.

[v-danhe-msft]

Hi @gerasimovav,

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

Regards,

Daniel He

[gerasimovav]

Hello, @v-danhe-msft

It's quite easy. For example the measue is 

Number of Orders = COUNTROWS(SENDING) 

Where table "Sending" looks like

 

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:

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:

Zero point apeared but with a lot of fake zero data

[Ashish_Mathur]

Hi,

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

[v-danhe-msft]

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:

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

[Greg_Deckler]

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