Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
I have calculated duration using start and end time.
Now I want to create bar graph that has the total duration grouped by reasondescription. It should look like this.
Instead of count I want "Total duration" for that category.
I was able to create a measure for total time, but I am not able to use it in any graph. Except as tooltips.
Total Time =
var a = SUMMARIZE(Table,groupbycolumn,"t",SUM(Table[Duration HH:MM:SS]))
return SUMX(a,[t])
Is there a way to get this done?
Thank you in advance!
Solved! Go to Solution.
is the attached sufficient ? How exactly should the Y axis values be shown?
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
This is the sample data below.
Id | DTStartTime | DTEndTime | Duration HH:MM:SS | ReasonDescription |
| 1 | 2/23/2023 12:00 | 2/23/2023 13:13 | 1:13:00 | A |
| 2 | 2/23/2023 11:44 | 2/23/2023 12:00 | 0:16:00 | A |
| 3 | 2/21/2023 18:00 | 2/21/2023 19:13 | 1:13:00 | B |
| 4 | 2/21/2023 12:00 | 2/21/2023 13:00 | 1:00:00 | B |
| 5 | 2/19/2023 7:45 | 2/19/2023 9:10 | 1:25:00 | D |
| 6 | 2/19/2023 2:50 | 2/19/2023 5:00 | 2:10:00 | D |
| 7 | 2/18/2023 17:51 | 2/18/2023 20:46 | 2:55:00 | F |
| 8 | 2/18/2023 12:00 | 2/18/2023 13:07 | 1:07:00 | D |
| 9 | 2/17/2023 6:30 | 2/17/2023 7:00 | 0:30:00 | F |
| 10 | 2/16/2023 8:36 | 2/16/2023 9:22 | 0:46:00 | D |
| 11 | 2/13/2023 12:00 | 2/13/2023 14:34 | 2:34:00 | B |
| 12 | 2/13/2023 0:00 | 2/13/2023 12:00 | 12:00:00 | G |
| 13 | 2/12/2023 12:00 | 2/13/2023 0:00 | 12:00:00 | G |
| 14 | 2/12/2023 11:34 | 2/12/2023 12:00 | 0:26:00 | G |
| 15 | 2/10/2023 7:18 | 2/10/2023 7:48 | 0:30:00 | D |
| 16 | 2/10/2023 6:00 | 2/10/2023 6:42 | 0:42:00 | D |
| 17 | 2/10/2023 0:00 | 2/10/2023 2:26 | 2:26:00 | E |
| 18 | 2/9/2023 22:26 | 2/10/2023 0:00 | 1:34:00 | E |
| 19 | 2/5/2023 0:00 | 2/5/2023 2:06 | 2:06:00 | B |
| 20 | 2/4/2023 21:34 | 2/5/2023 0:00 | 2:26:00 | F |
| 21 | 2/4/2023 8:11 | 2/4/2023 9:11 | 1:00:00 | D |
| 22 | 2/2/2023 16:07 | 2/2/2023 23:02 | 6:55:00 | D |
| 23 | 2/1/2023 12:00 | 2/1/2023 15:51 | 3:51:00 | B |
| 24 | 2/1/2023 0:00 | 2/1/2023 12:00 | 12:00:00 | G |
| 25 | 1/31/2023 12:00 | 2/1/2023 0:00 | 12:00:00 | G |
| 26 | 1/31/2023 0:00 | 1/31/2023 12:00 | 12:00:00 | G |
| 27 | 1/30/2023 12:00 | 1/31/2023 0:00 | 12:00:00 | G |
| 28 | 1/30/2023 10:58 | 1/30/2023 12:00 | 1:02:00 | D |
| 29 | 1/29/2023 1:29 | 1/29/2023 6:19 | 4:50:00 | E |
And below is how I want the expected outcome to be. Group total time but Reason codes.
Let me know if you want anything else. Thank you helping out.
I was trying to get hours and minutes format.
But this will work as well, thanks a lot.
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 56 | |
| 52 | |
| 42 | |
| 16 | |
| 16 |
| User | Count |
|---|---|
| 107 | |
| 104 | |
| 39 | |
| 35 | |
| 25 |