Forum Discussion
Duration in Column Chart
Hello,
I'm in trouble with duration in a Column Chart.
I have a table (tbDuration):
Data Type: Time (Start/Finish/Duration)
To sum Duration, I had to create 6 measures:
1 - TotalDuration = SUM(tbDuration[Duration])
2 - Days = INT([TotalDuration])
3 - Hours = FORMAT([TotalDuration], "HH")
4 - Minutes = FORMAT([TotalDuration], "nn")
5 - Seconds = FORMAT([TotalDuration], "ss")
6 - NewDuration = [Days]*24+[Hours]&":"&[Minutes]&":"&[Seconds]
And I added in a table to sum NewDuration and it worked !!
But, now I need to put this result in a Stacked Column Chart like this:
I've tried some ways, but it didn´t work yet.
Thanks for any help.
MRBranco
Hi MRBranco ,
Would you please refer to https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/td-p/793639 and use custom formart for it :https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-september-2019-feature-summary/#customFormatStrings
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
3 Replies
- amitchandakSuper User
MRBranco , measure it a text column. You will able display but in visual you have to use duration(Time) Type measure only.
- MRBrancoFrequent Visitor
amitchandak, thanks for your help.
But I didn't get it. 😞
Is it possible to send me an example?
Thanks in advance !
MRBranco
- v-deddai1-msftCommunity Support
Hi MRBranco ,
Would you please refer to https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/td-p/793639 and use custom formart for it :https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-september-2019-feature-summary/#customFormatStrings
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai