Forum Discussion
Time format legend
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.
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 documentationHow to Get Your Question Answered Quickly - Microsoft Fabric Community
Best Regards,
Albert He
3 Replies
Sorry, I posted the wrong message, here's the right one.
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.
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 documentationHow to Get Your Question Answered Quickly - Microsoft Fabric Community
Best Regards,
Albert He
