Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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:   There is zero value on 1 May, but, as you ca...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous,

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