The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.