Newbie trying to figure out how to structure data for a Gantt chart

[Siduna]

I have some tables I need to process in order to create a Gannt chart. I wish to sort the tasks/roles per person. The challenge is that I have one table (A) that includes the dates for the Gantt chart and the id of the project managers. The same persons can also be assigned projects without leading them. This is stored in another table (B) with reference to the file that contains project data (A).

When I build this in Microsoft Acess I simply created a query that created a table containing ProjectID, PersonId and Role ("Lead" or "Assisting"). I then linked this table to others to get the additional data I needed. Can this be done in Power BI or can I get the result in any other way?

The "resource" column in the Gantt chart would like something below (and the the Gantt bars would follow to the right):

Name      Role

Mike P     Lead

                Assisting

Peter N    Lead

                Lead

                Assisting

[AmiraBedh · Accepted solution]

In PQ, use  "Append Queries"  to combine your tables. You should have a table where each row contains a ProjectID, PersonID, Role (Lead or Assisting), Start Date, and End Date.

Then create a calculated column :

Resource = TableA[PersonID] & " - " & TableA[Role]

Then create your Gantt chart.