Time format legend

[bdel]

Hello,
I would like to create graphs that use a "Duration" column.
This column is in decimal format (for example, 01:00:00 = 0.04166...7).
I can use this to create graphs that calculate averages, sums, etc., which is perfect. However, I'd still like the legend of these graphs to display a readable format such as hh:mm:ss. I can't do it. For example, if the maximum of my graph is 01:30:00, the legend displays 0.06 (which is true, but unreadable).
I tried to change the format by adding a column in DAX = FORMAT(table[duration], "hh:mm:ss").
But when I use this column to make graphs, it doesn't work.
What can I do?
Thanks in advance for your help.

[Anonymous · Accepted solution]

HI @bdel ,

According to your describe, I try to reproduce your problem.
I created a time column and set the format to decimal. Here's a screenshot of my test:

1.Create a table visualization , use duration column and value column.

2.Create a new calculate column using DAX

Column = TIMEVALUE(FORMAT('Table'[Duration],"hh:mm:ss"))

3.change type of column format

4.Add the column into table visualization

5.Final output

From my test, your DAX formula is right. If you still can't do it, please provide your documents and hide your personal information.
In order for you to solve the problem faster, you can refer to the following documentation

How to Get Your Question Answered Quickly - Microsoft Fabric Community

Best Regards,
Albert He

 

[gmsamborn]

Hi @bdel 

I've run into this in the past and had to use a less than ideal solution.

I duplicated that column and formatted it as hh:mm:ss .  Then I used that as a tooltip whenever needed.

Initially the users hated it but they got used to it.  I would still like to find a better way but nothing has come up.

[bdel]

Sorry, I posted the wrong message, here's the right one.