Gantt Chart with multiple stages & Dates (multiple Start and End dates)

[purpleline18]

Hi,

Im quite new to PowerBI ,

and I actually have use case which is pretty similar with solution given within this thread https://community.powerbi.com/t5/Desktop/Gantt-Chart-with-different-stages/m-p/1232712#M546350  .

However, there are some points which im not sure how to handle it.

1. How to keep value "NA" and blank within the date table. As this is to be kept for indication that particular stage is not available in the project.

2. How to display overlapped dates between stages, in the colored column.

Below is snap shot of my data sample.

Below is expected result : (still not sure how to show the overlapped dates for stages).

anybody could help advise?

[ahjamil]

Hi purpleline18,
Did you get a solution for this problem, I am struggling with something like this and looking for options.

[Hei_aQing]

hi @purpleline18 

1. Each field can only have one data format, which means that columns with "NA" can only be in text format. This can make calculations difficult.

2. Existing tables seem to struggle with issues like overlapping dates, try unpivoting some columns etc, or check custom visuals.