How to show average time in hh:mm:ss instead of decimal value

[abhishek_300]

Hi ,

I want to show the average resolve time for the issues handle by user. So i have a column which has the Total time take for resolving an issue in hh:mm:ss format. However when i create an average resolution time by dax it populates this value in decimal point instead of the hh:mm:ss. I want to put this average resolution time in a line anc clustered column chart under Line values and show this data in hh:mm:ss format.Could you please advise how i can show in the lines values in hh:mm:ss format.

[Ashton_Quincey]

I have been able to change the format but now the format type is "Text" and I cannot add any conditional formatting to the average time if it's above a certain amount. Conditional Formatting on "Text" will only work for what the data "Contains"

[AlexChen]

Hi,

For example, you have a table below:

You can write a measure to get average time:

avgTime = Format(AVERAGE(timeAvg[time]), "HH:MM: SS")

Then you can see the result is in time format.

[leandro_sardinh]

That worked for me Thanks

[jorgeaguirre]

This is just what I need to do but I can not make it work.

[DanWalsh83]

This has worked for me, but when I try to change the visual to a graph (line, bar or column) the graph is blank. why is this?

[Anonymous]

same situtation here. Did you get a solution?

[Anonymous]

Have you already came across a solution? Got the same problem here 😞