Call Centre Duration in a line graph

[craigmon]

Guys, Is it still the case that we are unable to put time duration into a line graph.  Its defo not letting me do it at the moment.  The below shows the average outbound call time each contact centre operative.  This is so easy to do in Excel why can it not be done in Power BI?

Thanks

[negi007]

@craigmon you can convert your time values into minutes and then show minutes in the chart like below

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

let me know if it works for you.

[craigmon]

Thanks for that. It does work on some of my columns but not on the below measures.  Is there any way around this?  Many thanks

Total outbound time average =

VAR Seconds = SUMX ( 'Calls SQL', SECOND ( 'Calls SQL'[Out Time] ) + MINUTE ( 'Calls SQL'[Out Time] )*60 + HOUR ( 'Calls SQL'[Out Time] ) *3600 )

var Seconds1 = divide(Seconds,[Count of Names])

RETURN

quotient(Seconds1,3600 ) & ":" & FORMAT ( quotient(mod(Seconds1,3600 ),60), "00" ) & ":" & FORMAT ( mod(mod(Seconds1,3600 ),60), "00" )

Total inbound time new measure = VAR Seconds1 = SUMX ( 'Calls SQL', SECOND ( 'Calls SQL'[Total Inbound Time] ) ) VAR Minutes1 = SUMX ( 'Calls SQL', MINUTE ( 'Calls SQL'[Total Inbound Time] ) ) VAR Hours1 = SUMX ( 'Calls SQL', HOUR ( 'Calls SQL'[Total Inbound Time] ) ) VAR Seconds2 = MOD ( Seconds1, 60 ) VAR Minutes2 = MOD ( TRUNC ( Seconds1 / 60 ) + Minutes1, 60 ) VAR Hours2 = Hours1 + TRUNC ( ( TRUNC ( Seconds1 / 60 ) + Minutes1 ) / 60 ) RETURN Hours2 & ":" & FORMAT ( Minutes2, "00" ) & ":" & FORMAT ( Seconds2, "00" )

[negi007 · Accepted solution]

@craigmon in this case i suggest you to first create a calculate column to convert timevalues into seconds so that all values are in seconds. Then you create a measure to arrive a minute calculation. This should be able to help you.

Calculated column:

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

Measure:

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

now you can use the measure in our chart. let me know if it helps you. thanks

[amitchandak]

@craigmon , As far as I know, as of know y-axis do not support time