Graph with time in y axis

Anonymous , you might not be able to show in duration convert to min and use

 

in Min = hour([A_time])*60 +Minute([A_time])+second([A_time])/60 

 

Also refer : Duration
https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-dax
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-in-dax.aspx
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageKey=814a2cb4-3cca-4cd1-a620-c467adeaaaf6&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

Hi, Anonymous 

 

It is unsupported to put a column whose data type is time in 'Values'. Only number data type columns can be put in 'Values'. I'd like to suggest you unify the unit to seconds. I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

 

You may create a calculated column as below.

TotalSeconds = HOUR([A_TIME])*3600+MINUTE([A_TIME])*60+SECOND([A_TIME])

 

 

Result:

 

Best Regards

Allan

 

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