Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Funnel Data Format

Hi,   I need some help on a graph I'm trying to build.   Here is a sample from my data : the second column is a duration in seconds.   2019-12-24 08:00:00.0000000 303 2019-12-24 20:00:00...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    Hi, Anonymous 

     

    It is unsupport to put a formatted text in 'Values' of a visual. Only number data type can be put in the 'Values'. I'd like to suggest you calculate the total hours or total minutes as a workaround.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Tahreem24's avatar
Tahreem24
Super User
5 years ago

Anonymous ,

Try like below:

Duration = FORMAT(Table[Date],"HH:MM")

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi,

     

    Thank you for your help.

    Unfortunately, it doen't work either : the result is the same than with AvDur = TIME(0,0,AVERAGE('File1'[Duration]))

    In values, adding the column gets us : "Number of Duration" and we get values such as 344 instead of something like 01:20.

     

    Do you have something else to try ?

     

    Best regards,

     

    Martin.