Forum Discussion
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 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.
5 Replies
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
Hi Anonymous,
Could you please share some sample data to have a test if possible?
Regards,
Daniel He
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
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
