Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
abhishek_300
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.

7 REPLIES 7
Anonymous
Not applicable

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
Microsoft Employee
Microsoft Employee

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

That worked for me Thanks

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

Untitled.png

 

 

 

 

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
Not applicable

same situtation here. Did you get a solution?

Anonymous
Not applicable

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.