Showing Line Chart (Date Vs TIme in hh:mm format)

[Anonymous]

Hi Community,

we want to show the avg. in time w.r.t date having a filter to a category. 

I tried to convert the time format to Minutes or seconds but when doing average, values are coming wrong

like 10.68, etc.,

I did some search in the community as well no of the solutions are meeting my requirement.

Attached the sample data for reference.

https://drive.google.com/open?id=1BJHXBCD7sGeviVLvWrreTLZitu3Mkw5c

I need very urgent help on this on a solution or any alternatives.

Thanks in advance

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may use below dax to get the average.

Intime_cal = DIVIDE(HOUR('Sample Data'[InTime])*60*60+MINUTE('Sample Data'[InTime])*60+SECOND('Sample Data'[InTime]),24*60*60)

Measure = TIME(0,0,0)+ AVERAGE('Sample Data'[Intime_cal])

Regards,

[Anonymous]

Thanks For your reply,

My requirement is to represent  the average time in line chart  and measure calculated in the data is in time format so we cant do

Any Suggestion on this.

Thanks

Yamuna

[v-cherch-msft]

Hi @Anonymous 

It's impossible to use Time format for y-axis.As Y-axis supports only numeric values currently.I would suggest you use tooltips to show their time format.

Regards,

[Anonymous]

Thanks v-cherch-msft 

I did the same 

Thanks