Time Stamp Analysis Visual

Hi Anonymous ,

To my knowledge, your requirement——Show Time format value for Y-axis could not be realized currently.

Ideas similar with what you expect have been submitted in the following links, please vote them up and you can add comments. Hopes Power Bi will implement this in nearby future.

Support y-axis time values

Chart Time HH:MM:SS in Y-Axis

dates and times on the y-axis of a graph

My workaround is Switch Time to Number type for Y-axis , and apply the Time format to Tooltips pane:

1. Add column: get total seconds

Time(Seconds) = HOUR([Time]) *3600 +MINUTE([Time])*60+SECOND([Time])

2. Create a measure to get the average seconds, and then change to Time type

Avg Time format = 
var avgSec= CALCULATE(AVERAGE('Table'[Time(Seconds)]),ALLEXCEPT('Table','Table'[WeekDay]))
var h=INT(avgSec/3600)
var m=INT( (avgSec - h*3600) / 60)
var s=avgSec-  h*3600 -m*60
return  TIME(h,m,s)

Output:

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