Actual vs scheduled Timing graph

[Anonymous]

I have 2 columns  which are scheduled surgical time (hh:mm AM/PM) and actual surgical time (hh:mm AM/PM). I am trying to plot a comparision graph but I was not able to. Any ideas on how to plot this. I have tried all the visualization but no graph was not able to plot time.

[negi007]

@Anonymous  in this case i would suggest you to convert time values in your data to minutes or seconds by adding a column in your data and then you can create a measure to calculate time which can be used in your chart

Column to convert time into seconds

time(seconds) = (HOUR('Table'[Time])*60*60 + MINUTE('Table'[Time])*60)

measure to convert time into minutes

time(minutes) = SUM('Table'[time(seconds)])/60

use the measure in your chart that will help you to compare actual vs schedule time. 

do let me know if you still need further help on this. thanks

[amitchandak]

@Anonymous , I think on x-axis you should be able to plot time.

You can create a time table and join both time's with it. and create one measure with userelationship where the relationship is inactive 

https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi