Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
I am at a real loss for what I assume is a simple solution. Any help would be greatly appreciated!
Solved! Go to 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.
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.
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.
@aaabbbccc You can force the y-axis to start at zero.
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |