Chart to show 0's in line graph

[aaabbbccc]

I have this:

using this data:

CustomerOrderNumber	OrderNumber	CustomerPONumber	CreateDate	CreateDateOnly
83885943	289100	HOT SHOT	1/24/2022 22:20	1/24/2022 22:20
83886064	289373	HOT SHOT	1/25/2022 14:11	1/25/2022 14:11
83887779	292932	HOT SHOT	2/7/2022 1:45	2/7/2022 1:45
83888338	294157	HOT SHOT	2/10/2022 5:44	2/10/2022 5:44
83892719	303884	HOT SHOT	3/12/2022 16:06	3/12/2022 16:06
83892982	304435	HOT SHOT	3/15/2022 0:50	3/15/2022 0:50
83893278	305193	HOT SHOT	3/16/2022 17:36	3/16/2022 17:36
83893305	305231	HOT SHOT	3/16/2022 20:59	3/16/2022 20:59
83896233	311015	HOT SHOT	4/5/2022 9:06	4/5/2022 9:06
83896277	311217	HOT SHOT	4/5/2022 18:56	4/5/2022 18:56
83896327	311234	HOT SHOT	4/5/2022 21:26	4/5/2022 21:26
83896466	311548	HOT SHOT	4/6/2022 22:27	4/6/2022 22:27
83896473	311557	HOT SHOT	4/7/2022 0:47	4/7/2022 0:47
83896864	312342	HOT SHOT	4/11/2022 1:42	4/11/2022 1:42
83897025	312670	HOT SHOT	4/11/2022 23:47	4/11/2022 23:47
83897056	312700	HOT SHOT	4/12/2022 3:20	4/12/2022 3:20
83897464	313681	HOT SHOT	4/15/2022 0:41	4/15/2022 0:41
83898225	315474	HOT SHOT	4/22/2022 5:02	4/22/2022 5:02
83898286	315609	HOT SHOT	4/22/2022 14:49	4/22/2022 14:49
83898558	316216	HOT SHOT	4/25/2022 21:32	4/25/2022 21:32
83898565	316230	HOT SHOT	4/25/2022 23:02	4/25/2022 23:02
83898720	316540	HOT SHOT	4/26/2022 21:30	4/26/2022 21:30
83898772	316608	HOT SHOT	4/27/2022 5:50	4/27/2022 5:50
83898938	316934	HOT SHOT	4/28/2022 3:16	4/28/2022 3:16
83899038	317232	HOT SHOT	4/28/2022 20:46	4/28/2022 20:46
83899440	318054	HOT SHOT	5/2/2022 22:47	5/2/2022 22:47
83899773	318998	HOT SHOT	5/4/2022 20:41	5/4/2022 20:41
83899855	319094	HOT SHOT	5/5/2022 7:38	5/5/2022 7:38
83900167	319944	HOT SHOT	5/9/2022 3:01	5/9/2022 3:01
83901309	322356	HOT SHOT	5/18/2022 6:45	5/18/2022 6:45
83901698	323417	HOT SHOT	5/21/2022 21:08	5/21/2022 21:08
83901699	323418	HOT SHOT	5/21/2022 21:13	5/21/2022 21:13
83901700	323419	HOT SHOT	5/21/2022 21:13	5/21/2022 21:13
83901720	323466	HOT SHOT	5/22/2022 13:08	5/22/2022 13:08

and my line graph only goes to 1, not to 0.  The Y axis is set to:

In researching I found that a common solution is If I change the line graph from "Count of CustomerOrderNumber" to:

Measure 2 = count(ShipmentOrder[CustomerOrderNumber])+0

but that just makes my graph stop respecting the date filters:

I am at a real loss for what I assume is a simple solution.  Any help would be greatly appreciated!

[v-yalanwu-msft · Accepted solution]

Hi, @aaabbbccc ;

You could create another table as x-axis.

Date = CALENDAR(MIN('Table'[CreateDate]),MAX('Table'[CreateDate]))

Then create a measure.

Measure = CALCULATE(COUNT('Table'[CustomerOrderNumber]),FILTER('Table',FORMAT([CreateDate],"yyyy-mm-dd")=FORMAT(MAX('Date'[Date]),"yyyy-mm-dd")))+0

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[aaabbbccc]

If I set the Y axis to zero, then it shows zero:

but since there are no values that are actually 0 it doesn't "dip like it should".  In the example above I would expect the line to be at 0 from 5/10-5/17 because there are no orders that qualify.

[Greg_Deckler]

@aaabbbccc You can force the y-axis to start at zero.