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.

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