Help a beginner with a line chart showing run times.

[JeffMullins]

Hi. Beginner here trying to put together a line chart with average run times from 3 different dates. I am importing the data from excel, and I understand excel does not support "duration", which is a pain.

I have tried using a time format, and the numbers are accurate, but it only gives me a count option (1). See below: 

I have also tried using a decimal number format, but the numbers are not accurate (minutes and seconds). See below:

I have a thought on the solution, but cannot figure out how to accomplish it. If I could convert the "decimal number" to calculate "60 seconds equals 1 minute" rather than "100 fractions equals 1 whole", this would be a solution. I've tried to solve this issue many different ways on my own but havent been able to figure it out.  I'm thinking using a measure, formula or DAX is the solution? Any help would be greatly appreciated.

Jeff  

 

 

  

[v-jianboli-msft · Accepted solution]

Hi @JeffMullins ,

Please try:

Measure = HOUR(MAX('Table'[1 1/2 Mile Run]))*60+MINUTE(MAX('Table'[1 1/2 Mile Run]))

Apply it to the line chart:

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PaulDBrown]

For any visual which displays values, you cannot use a field/measure in time format. You need to convert it to a decimal number. You can however display Time format as a tooltip