Data and Time manipulation

[MNGoodyear]

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 changing the format to just date but the x axis still displays the time

I also want to group the date time by 15 minute groupings for another graph but unsure how to achieve.

Any help would be appreciated

[amitchandak]

@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]

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

[MattAllington]

You should create a view in SQL that strips out the time