Forum Discussion
Solved
Plot date/time format as unit on x-axis
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 ...
Hi ZalinaBaskaty
You can use the gantt chart:
Main sources for acquiring Power BI custom visuals - Power BI | Microsoft LearnBest Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is exactly what I was looking to do. Thank you so much! You saved my day.
No. Please review the link.
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