Forum Discussion
Display time and duration
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
1 Reply
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
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.
