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
Super User
6 years agoMNGoodyear , Try a time table
https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/
- MNGoodyear6 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