How to make visual graph with time data

[Anonymous]

Hi everyone,

I have some measures of type hh:mm:ss and I would like to see them in a visual graph but PowerBi doesn't allow me to select them in a graph. Is there a way to display the time measurements on a graph?

Thanks in advance.

[v-yanjiang-msft]

Hi @Anonymous ,

Time type columns can display normally in Rows in a graph, but when be put in Y axis, it can only show count of the value, because Y axis always shows result, not conditions.

Best Regards,
Community Support Team _ kalyj

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

[Anonymous]

Thanks @amitchandak for your help. 

Then,that means it's not possible to display time on Y axis  as it's what I wanted

[amitchandak]

@Anonymous , I doubt you can display time on Y axis

To sum up duration, you can refer

 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