Looking for suggestions and Help to find a best Visual to show the Data in Timeline.

[Power_Mate]

Hi There,

@Tahreem24 @Juan-Power-bi I am looking for help to find a visual to display the available data in the below shown visual.

I have worked with multiple Gantt Charts it didn't worked out.

I have 2 tables program name and program dates which i have pasted the dummy data

I want to analyze the data of each program with its different phases in the year timeline.

For example :

P1 has 4 phases then all phases should be displayed in single stack showing phase 1, phase 2, phase 3 and Phase 4 as a legend.

As shown in the below image.

Program name on x axis and  year on y axis.

Prgram Name		Praogram Dates
Program_ID	Program_Name	Current_Phase	Start Date	End Date		Program_ID	Phase 1 Start date	Phase 1 End Date	Phase 2 Start Date	Phase End Date	Phase3 Start date	Phase 3 End Date	Phase 4 Start Date	Phase 4 End Date
1	P1		01-09-20	20-12-21		1	01-09-20	28-12-20	28-12-20	26-04-21	26-04-21	23-08-21	23-08-21	20-12-21
2	P2		01-08-22	22-12-23		2	01-08-22	06-12-22	06-12-22	12-04-23	12-04-23	17-08-23	17-08-23	22-12-23
3	P3	2	28-04-21	25-02-25		3	28-04-21	12-04-22	12-04-22	28-03-23	28-03-23	12-03-24	12-03-24	25-02-25
4	P4	3	01-02-20	30-06-22		4	01-02-20	08-09-20	08-09-20	16-04-21	16-04-21	22-11-21	22-11-21	30-06-22
5	P5	3	06-01-20	30-05-26		5	06-01-20	12-08-21	12-08-21	19-03-23	19-03-23	23-10-24	23-10-24	30-05-26
6	P6		14-01-20	01-01-23		6	14-01-20	10-10-20	10-10-20	08-07-21	08-07-21	05-04-22	05-04-22	01-01-23
7	P7	1	03-02-20	08-07-22		7	03-02-20	11-09-20	11-09-20	21-04-21	21-04-21	28-11-21	28-11-21	08-07-22
8	P8	1	27-09-21	12-12-22		8	27-09-21	15-01-22	15-01-22	05-05-22	05-05-22	23-08-22	23-08-22	12-12-22
9	P9	2	16-01-20	30-11-22		9	16-01-20	04-10-20	04-10-20	23-06-21	23-06-21	12-03-22	12-03-22	30-11-22
10	P10		01-11-20	30-12-22		10	01-11-20	17-05-21	17-05-21	30-11-21	30-11-21	15-06-22	15-06-22	30-12-22

[lbendlin]

What's wrong with Gantt charts?

See attached

[Power_Mate]

First of all i thank you for your efforts!

I have shared 2 tables. First table consists of Program, start and End dates and current Phase.

Second table consists of Phase1,phase2, phase3 stages using start and end dates

Now i need to show case all the phases of program.

Ex. P1 has 3 phases (Phase 1, Phase 2 and Phase 3).

now in single stack i need to show from when to when phase 1,2 and 3 had taken place.

[lbendlin]

This is the best I can do, with a fake calculated Phase 0 that is rendered white

And no, I cannot change the x axis.

See attached.

[Power_Mate]

I appreciate your help so much!

I acchevied the same by calculating the number of days between the Start and End date.

But the thing is to achive the X-axis as Year.

[lbendlin]

As I said I cannot help you with that. Maybe someone else has an idea.