Forum Discussion

bdel's avatar
bdel
New Member
2 years ago
Solved

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, ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 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 documentation

    How to Get Your Question Answered Quickly - Microsoft Fabric Community

    Best Regards,
    Albert He

     

gmsamborn's avatar
gmsamborn
Super User
2 years ago

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.