Display time and duration

[jcleary]

I am trying to display delivery times in the graph in PBI to show operational delivery improvements. 

Please see below the data list I am trying to display.   I can show it if I change to a decimal but then the numbers are not correct  and the Y axis displays incorrectly.   I wanted to just show the time as you mouse over the line and the Y axis to display how long it took  

I am somewhat new to Power BI but after spending a few days trying to figure this out I am hoping that the community can get me unstuck.    I appreciate any help Thank you

[Eric_Zhang]

---

@jcleary wrote:

I am trying to display delivery times in the graph in PBI to show operational delivery improvements. 

Please see below the data list I am trying to display.   I can show it if I change to a decimal but then the numbers are not correct  and the Y axis displays incorrectly.   I wanted to just show the time as you mouse over the line and the Y axis to display how long it took  

I am somewhat new to Power BI but after spending a few days trying to figure this out I am hoping that the community can get me unstuck.    I appreciate any help Thank you

---

@jcleary

In your table, is there only one row for each DATE?

I think you can create a decimal column that indicate the duration in hours, put this column to the Values field. To see the time format, create a calculated column shows "hh:mm" format and put it in the Tooltips field.