Forum Discussion
bdel
2 years agoNew Member
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, ...
- Anonymous2 years ago
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
bdel
2 years agoNew Member
Sorry, I posted the wrong message, here's the right one.