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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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