Insert sum of hours measure in chart

[Anonymous]

Hello, 

I try to put a sum of hours measure in a char, but I can't.

I have this base:

Type	Duration (hh:mm:ss)
1	00:03:00
1	00:03:00
1	00:03:00
2	00:04:00
2	00:04:00
2	00:04:00
3	00:02:00
3	00:04:00
3	00:03:00
Measure(total)	0:30:00

The measure is the sum of duration (hh:mm:ss)

My line chart need to show this info: Type 1 = 00:09:00 - Type2 = 00:12:00 - Type3 = 00:09:00

 I need something like this.

Anyone can help me??

Thanks a lot.

[FreemanZ]

hi @Anonymous 

you can just SUM it, try to write a measure like:

Measure = FORMAT(SUM(TableName[Duration (hh:mm:ss)]), "hh:mm:ss")

it worked like this:

[Greg_Deckler · Accepted solution]

@Anonymous You need this: Chelsie Eiden's Duration - Microsoft Power BI Community