Forum Discussion
Anonymous
7 years agoNot applicable
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...
Anonymous
7 years agoNot applicable
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
Super User
7 years agoHi,
Share the link from where i can download your PBI file.