Forum Discussion
MNGoodyear
6 years agoFrequent Visitor
Data and Time manipulation
I have a data set as a direct query from a SQL database. This includes a Date time field as shown below: I would like to use the value as just a date field in in a graph, I have tried ...
amitchandak
6 years agoSuper User
MNGoodyear , Try a time table
https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/
MNGoodyear
6 years agoFrequent Visitor
Hi,
I followed your instructions and have created a time table, this allows me to allocate a time slot to production. I can then graph this, however what this doesn't show me is the points of zero production.
For example if i plot the below data it will not show 0 for the 30 minute slots between 12:30 and 1:30 and i would like to sum every time slot between 7am and 7 pm and display zero where no production:
| date_time | code | Qty | WL_Barcode | Slot | Hour |
| 11/08/2020 12:19 | Apple | 1 | 1 | 0-29 | 12 |
| 11/08/2020 12:19 | Apple | 1 | 2 | 0-29 | 12 |
| 11/08/2020 12:19 | Apple | 1 | 3 | 0-29 | 12 |
| 11/08/2020 12:19 | Apple | 1 | 4 | 0-29 | 12 |
| 11/08/2020 12:20 | Apple | 1 | 5 | 0-29 | 12 |
| 11/08/2020 12:20 | Apple | 1 | 6 | 0-29 | 12 |
| 11/08/2020 12:23 | Apple | 1 | 7 | 0-29 | 12 |
| 11/08/2020 12:23 | Apple | 1 | 8 | 0-29 | 12 |
| 11/08/2020 12:28 | Apple | 1 | 9 | 0-29 | 12 |
| 11/08/2020 12:28 | Apple | 1 | 10 | 0-29 | 12 |
| 11/08/2020 13:31 | Apple | 1 | 11 | 30-59 | 13 |
Thanks