Gantt chart based on Fridays?

[NewBee117]

Hi, there, I have a job table, need to show it in color coded chart, help please.

Here is the data table, I also created a calendar table with just Fridays.

Here is the output I am looking for, is it possible?

Alternatively, it could go vertical:

[v-shex-msft]

Hi @NewBee117,

I'd like to suggest you consider using r visual to manually poly these graphs, I don't think the Gantt chart can fully achieve your requirement.

Regards,

Xiaoxin Sheng

[NewBee117]

Any chance you can provide the r script that I can use/modify? I know Python, not much of R.

Here is the screen from the sample Power BI Desktop file. For my table, Job#, Start and End date, what does the R script look like? Thanks.

[v-shex-msft · Accepted solution]

Hi @NewBee117,

In fact, I think python visuals also suitable to do these operations. You only need to use them to plot the graph and try to rotate or change the axis of the display results:

Sample about use R script plot Gantt:
plot-gantt-method: Draw a Gantt diagram 
Regards,

Xiaoxin Sheng