Time formatting

[Misca]

I'm working on a tabular model where there's waiting times in seconds. I've calculated a measure that displays the average waiting time in seconds (10 sec = 10) but how can I show it in (hours) minutes and seconds? The normal number formatting doesn't seem to work ( Normal time formatting "hh:mm:ss" shows "hh:mm:ss" in letters. Even if the seconds are divided with 86400). I can display it in the right format using FORMAT-function but text doesn't work on charts that well...

The tabular model is created in Visual Studio and the measures can be created either in VS or PBI desktop.

 

[Matt Allington]

I think you need to convert the integer colum for seconds to a fraction of a day (divide by 60*60*24), set the column format to date and then format it as time.

 

[Misca]

Thanks for you suggestion. It works on row level in a column but what I'm after is a measure (average waiting time) that I can use in charts as well as in tables. And I just can't get the end result to look like time / duration at all. I've changed the data type of my additional column to time but when I try to average that, the measure is fixed to decimal and I can't change it.