Help with scatter chart and general visualization question

[newbie2powerbie]

Hi all,

I am fairly new to Power BI. After using power query to transform and merge queries I've run into a bit of a problem trying to build my report/dashboard.

What I am trying to do is graph a driver's expected delivery times versus actual delivery times for a given route. I am picturing a scatter chart of data from two separate columns: ExpectedTime and ActualTime, with time on the X-axis and order number on the Y-axis. However I can't really get it to display what I would like it to. Is there a way to accomplish this in PowerBI? Am I using the right visualization for the task? Any help would be greatly appreciated!

Here's a sample of the data I am trying to put into a visualization:

DriverName	OrderNumber	ExpectedTime	ActualTime
DRIVER1	1	1:00:00 PM	12:55:00 PM
DRIVER1	2	2:00:00 PM	2:05:00 PM
DRIVER1	3	3:00:00 PM	3:10:00 PM
DRIVER1	4	4:00:00 PM	4:05:00 PM
DRIVER1	5	5:00:00 PM	5:10:00 PM
DRIVER1	6	6:00:00 PM	6:20:00 PM
DRIVER1	7	7:00:00 PM	7:10:00 PM
DRIVER1	8	8:00:00 PM	8:30:00 PM

[v-rongtiep-msft]

Hi @newbie2powerbie ,

What is wrong with the merge? Please provide your desire output and the value.

Best Regards

Community Support Team _ Polly

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

[amitchandak]

@newbie2powerbie , You need to have this time in second or minutes to use that on the axis of scatter visual

Example

expected time in sec = hour([expected time])*3600 + minute([expected time])*60 + second([expected time])