Plot date/time format as unit on x-axis

[ZalinaBaskaty]

Hello Power BI Gurus,

Could someone help me plot this in Power BI?

I can't get X-axis to show Date/Time format in Power BI, like I do above.

I do need it to stay date/time (as opposed to time alone) because this is shift data and shifts can start on one date and finish on the next day.

Many thanks in advance for your help!

[Anonymous · Accepted solution]

Hi @ZalinaBaskaty 

You can use the gantt chart:

Main sources for acquiring Power BI custom visuals - Power BI | Microsoft Learn

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi @ZalinaBaskaty 

You can use the gantt chart:

Main sources for acquiring Power BI custom visuals - Power BI | Microsoft Learn

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ZalinaBaskaty · Accepted solution]

This is exactly what I was looking to do. Thank you so much! You saved my day. 

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[ZalinaBaskaty]

Sorry, is there a way to attach the .pbix file?

[lbendlin]

No. Please review the link.

[ZalinaBaskaty]

Operator ID	START_TIME	Interval	END_TIME
1	10/14/2020 7:22	0:21	10/14/2020 7:43
1	10/14/2020 7:55	0:06	10/14/2020 8:01
1	10/14/2020 8:01	0:09	10/14/2020 8:10
1	10/14/2020 8:10	0:04	10/14/2020 8:14
1	10/14/2020 8:14	0:05	10/14/2020 8:19
1	10/14/2020 8:19	0:03	10/14/2020 8:22
1	10/14/2020 8:22	0:02	10/14/2020 8:24
1	10/14/2020 8:24	0:05	10/14/2020 8:29
1	10/14/2020 8:29	0:05	10/14/2020 8:34
1	10/14/2020 8:39	0:13	10/14/2020 8:52
1	10/14/2020 8:54	0:04	10/14/2020 8:58
1	10/14/2020 8:58	0:02	10/14/2020 9:00
1	10/14/2020 9:00	0:01	10/14/2020 9:01
1	10/14/2020 9:11	0:06	10/14/2020 9:17
1	10/14/2020 9:17	0:03	10/14/2020 9:20
1	10/14/2020 9:20	0:07	10/14/2020 9:27
1	10/14/2020 9:27	0:08	10/14/2020 9:35
1	10/14/2020 9:35	0:04	10/14/2020 9:39
1	10/14/2020 9:39	0:04	10/14/2020 9:43
1	10/14/2020 9:43	0:04	10/14/2020 9:47
1	10/14/2020 9:47	0:03	10/14/2020 9:50
1	10/14/2020 9:51	0:20	10/14/2020 10:11
1	10/14/2020 10:11	0:03	10/14/2020 10:14
1	10/14/2020 10:17	0:26	10/14/2020 10:43
1	10/14/2020 10:43	0:25	10/14/2020 11:08
1	10/14/2020 11:08	0:16	10/14/2020 11:24
1	10/14/2020 11:24	0:06	10/14/2020 11:30
1	10/14/2020 11:30	0:04	10/14/2020 11:34
1	10/14/2020 11:34	0:12	10/14/2020 11:46
1	10/14/2020 11:46	0:02	10/14/2020 11:48
1	10/14/2020 11:48	0:03	10/14/2020 11:51
1	10/14/2020 11:51	0:03	10/14/2020 11:54
1	10/14/2020 11:54	0:03	10/14/2020 11:57
1	10/14/2020 11:57	0:10	10/14/2020 12:07
1	10/14/2020 12:12	0:04	10/14/2020 12:16
1	10/14/2020 12:22	0:04	10/14/2020 12:26
1	10/14/2020 12:33	0:05	10/14/2020 12:38
1	10/14/2020 12:38	0:04	10/14/2020 12:42
1	10/14/2020 12:42	0:15	10/14/2020 12:57
1	10/14/2020 12:57	0:08	10/14/2020 13:05
1	10/14/2020 13:11	0:02	10/14/2020 13:13
1	10/14/2020 13:13	0:02	10/14/2020 13:15
1	10/14/2020 13:18	0:04	10/14/2020 13:22
1	10/14/2020 13:22	0:03	10/14/2020 13:25
1	10/14/2020 13:25	0:05	10/14/2020 13:30
1	10/14/2020 13:30	0:03	10/14/2020 13:33
1	10/14/2020 13:33	0:02	10/14/2020 13:35
1	10/14/2020 13:35	0:05	10/14/2020 13:40
1	10/14/2020 13:40	0:01	10/14/2020 13:41
1	10/14/2020 13:41	0:01	10/14/2020 13:42
1	10/14/2020 13:42	0:01	10/14/2020 13:43
1	10/14/2020 15:19	0:06	10/14/2020 15:25
1	10/14/2020 15:25	0:11	10/14/2020 15:36
1	10/14/2020 15:36	0:07	10/14/2020 15:43
1	10/14/2020 15:43	0:07	10/14/2020 15:50
1	10/14/2020 15:50	0:03	10/14/2020 15:53
1	10/14/2020 15:53	0:03	10/14/2020 15:56
1	10/14/2020 15:56	0:03	10/14/2020 15:59

here is my sample data

[ZalinaBaskaty]

Sure thing... I am trying to figure out how to best to show data thats in the test tab table. It would represent for each warehouse worker, when are they at task vs idle. (Sorry, now I can't find how to attach a file here...)

[lbendlin]

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

[ZalinaBaskaty]

thank you - i will review your link now