Forum Discussion

joaoga1's avatar
joaoga1
Frequent Visitor
5 years ago
Solved

Displaying time (hh:mm:ss) on a chart

Hi everyone,    I'm currently working on a Power BI project and I ran into a problem. I want a bar chart, with different subjects, and for the bars I want a sum of hours worked on each subject (exa...
Need Help
Tips and Tricks
Tutorial Requests
  • Jimmy801's avatar
    Jimmy801
    5 years ago

    Hello joaoga1 

     

    you can create a new measure that gives you a text format as you need it. But as I think it's not possible to add this as label text, but only as tooltip. Here how the measure could look like (not tested)

    Measure = sumx('table', hour('table'[time])) + TRUNC(sumx('table', MINUTE('table'[time]))/60)  & ":" & mod(sumx('table', MINUTE('table'[time])), 60) & ":00"


    If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
    Kudoes are nice too

    Have fun

    Jimmy

     

  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi joaoga1 ,

    Just put the measure in the Tooltip field:

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Jimmy801's avatar
Jimmy801
Icon for Community Champion rankCommunity Champion
5 years ago

Hello joaoga1 

 

Datetime-formats cannot be summed. You have to create a measure like this

TimeValue = sumx('Table', hour('Table'[Hours])) +(sumx('table', MINUTE('Table'[Hours]))/60)  +  +(sumx('table', SECOND('Table'[Hours]))/60/60)

This gives you a digital version of your datetime like 19,5 so you can put it in the gannt. 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

 

  • joaoga1's avatar
    joaoga1
    Frequent Visitor
    5 years ago

    Jimmy thanks for the answer, it really helped!

    Altough, I need to visualize the amount of hours in the format of (hh:mm:ss) on the chart, is there any way I can do that?

    • Jimmy801's avatar
      Jimmy801
      Icon for Community Champion rankCommunity Champion
      5 years ago

      Hello joaoga1 

       

      you can create a new measure that gives you a text format as you need it. But as I think it's not possible to add this as label text, but only as tooltip. Here how the measure could look like (not tested)

      Measure = sumx('table', hour('table'[time])) + TRUNC(sumx('table', MINUTE('table'[time]))/60)  & ":" & mod(sumx('table', MINUTE('table'[time])), 60) & ":00"


      If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
      Kudoes are nice too

      Have fun

      Jimmy

       

      • joaoga1's avatar
        joaoga1
        Frequent Visitor
        5 years ago

        Thanks again Jimmy, but how do I add it as a tooltip?