Forum Discussion

NewBee117's avatar
NewBee117
Regular Visitor
5 years ago
Solved

Gantt chart based on Fridays?

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 look...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
NewBee117
Regular Visitor
5 years ago

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.

NewBee117_1-1605545635904.png

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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