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...
  • 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.