Forum Discussion
joaoga1
5 years agoFrequent Visitor
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...
- 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
5 years agoFrequent Visitor
Thanks again Jimmy, but how do I add it as a tooltip?