Any ideas to create this kind of chart? - almost Gantt Chart

[Jakub_Poweska11]

Hello,

i am loooking for insipration to create this kind of chart:

Generally is similar to Gantt Chart, but instead of having time on X-axis, we have % of time spend ticket assigned to to particular time.

I tried create a normal Gantt Chart with custom visuals, but for my specific data, they are not exactly applicable and they are looking bad.

Regards,

Kuba

[Rupak_bi · Accepted solution]

Hi @Jakub_Poweska11 ,

Here I have tried to replicate the sample data using Matrix.

Steps:

1. Add three new columns:

flag = switch('Table'[Assignment Group],"TEAM A",1,"TEAM B",2,"TEAM C",3,"TEAM D",4,"TEAM E",5)

CUM_second = CALCULATE(sum('Table'[Total Time in Second]),all('Table'),'Table'[Start]<=EARLIER('Table'[Start]))

Percentage = 'Table'[CUM_second]/max('Table'[CUM_second])

2. Now use matrix visual and configure as below:

3. Go to cell element, do conditional formatting for background and font colour with same logic

Now you will get the gantt chart.

Let me know if this works. If yes, plz accept as solution........

[danextian]

This is partly achievable with the native matrix visual - partly because you cannot merge the value cells. This may also require a considerable amount of development time. 

[Rupak_bi]

Hi @Jakub_Poweska11 ,

this can be achieved using a matrix visual in Power BI with required data modelling and measures. A sample data with expected result will help to workout.

[Jakub_Poweska11]

Hey,

im sending a sample data for this case:

Assignment Group	Start	End	Business Elapsed Time formatted from second	Total Time in Second
TEAM A	5/16/2025 9:53	5/16/2025 9:58	05m:29s	329
TEAM A	5/16/2025 9:58	5/16/2025 14:34	04h:32m:58s	16378
TEAM A	5/16/2025 14:34	5/16/2025 19:14	04h:25m:07s	16748
TEAM A	5/16/2025 19:14	5/17/2025 0:10		17795
TEAM A	5/17/2025 0:10	5/19/2025 3:49	49m:44s	185948
TEAM A	5/19/2025 3:49	5/19/2025 5:15	01h:25m:32s	5132
TEAM B	5/19/2025 5:15	5/19/2025 9:54	04h:39m:08s	16748
TEAM A	5/19/2025 9:54	5/19/2025 10:22	28m:21s	1701
TEAM B	5/19/2025 10:22	5/19/2025 12:39	02h:17m:12s	8232
TEAM C	5/19/2025 12:39	5/20/2025 9:49	13h:09m:53s	76193
TEAM A	5/20/2025 9:49	5/20/2025 11:50	02h:00m:48s	7248
TEAM B	5/20/2025 11:50	5/20/2025 13:41	01h:51m:19s	6679
TEAM A	5/20/2025 13:41	5/20/2025 14:20	38m:09s	2289
TEAM D	5/20/2025 14:20	5/21/2025 20:07	20h:39m:54s	107224
TEAM A	5/21/2025 20:07	5/22/2025 9:47	06h:47m:33s	49223
TEAM D	5/22/2025 9:47	5/23/2025 12:06	18h:19m:02s	94742
TEAM A	5/23/2025 12:06	5/23/2025 12:46	39m:46s	2386
TEAM E	5/23/2025 12:46	5/23/2025 12:55	08m:59s	539
TEAM E	5/23/2025 12:55	5/26/2025 8:44	11h:49m:08s	244148
TEAM B	5/26/2025 8:44	5/27/2025 9:54	17h:10m:04s	90604
TEAM E	5/27/2025 9:54	5/27/2025 11:33	01h:38m:41s	5921
TEAM B	5/27/2025 11:33	5/27/2025 14:39	03h:05m:54s	11154
TEAM A	5/27/2025 14:39	5/27/2025 15:17	38m:26s	2306
TEAM E	5/27/2025 15:17	5/27/2025 15:54	37m:04s	2224
TEAM B	5/27/2025 15:54	6/4/2025 12:11	3 days 20h:17m:09s	677829
TEAM B	6/4/2025 12:11		2 days 14h:52m:08s	514328