Forum Discussion
Help with scatter chart and general visualization question
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 |
2 Replies
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])
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.
