Duration in Column Chart

[MRBranco]

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

[amitchandak]

@MRBranco , measure it a text column.  You will able display but in visual you have to use duration(Time) Type measure only.

https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...

[MRBranco]

@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-msft · Accepted solution]

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/#customForm...

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