Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
Solved! Go to 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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
72 | |
62 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
62 | |
59 | |
56 |