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 looking for, is it possible?

 

Alternatively, it could go vertical:

 

 

 

 

  • 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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

      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

        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