cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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

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.

5 REPLIES 5
Highlighted
Microsoft
Microsoft

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

Hi,

 

For example, you have a table below:

1.png

 

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.

 

2.png

Highlighted
Frequent Visitor

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

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

Untitled.png

 

 

 

 

Highlighted
New Member

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

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?

Highlighted
Helper II
Helper II

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

same situtation here. Did you get a solution?

Highlighted
Anonymous
Not applicable

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

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

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors