Graph with time in y axis

[Anonymous]

Hi,

I needo to build a chart when x axis has months and y axis has avg time of during the calls  similar :

I have a table below:

But I can not do the chart, it appears as:

I don´t know what is problem.

Can I help me please?

Thanks

[v-alq-msft]

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.

[amitchandak]

@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

[Anonymous]

I can´t build the graph as I intend?