Forum Discussion

MRBranco's avatar
MRBranco
Frequent Visitor
6 years ago
Solved

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

3 Replies