i have a table with one column having project id's and 3 columns having dates of phases :
I want to create a GANTT chart with this table and show the phases of each project. I tried but can't get it to work. Any suggestions pls..
Go to Solution.
I tried to re-pro the issue from my end and got the below.
I just pasted your data by using the "enter data".
Home >> Edit queries >> Edit Queries >> (before select the mulitple columns for the unpivot by clicking on "CTRL") >> Unpivot Columns
Hope it will help for your issue.
If you have any issues, please let us know.
If this post helps, then please consider Accept it as the solution to help the other members find it moreIf this post was helpful may I ask you to mark it as solution and click on thumb symbol?
View solution in original post
Proud to be a Datanaut!
thanks for the reply. I tried several things: transpose, unpivot but can't get my data in order.
I know i need to get my data in this form:
but i can't get to do it. when i unpivot my original table i get this table:
Phase1 Date Phase2 Date Phase3 Date Attribute Value
Hi @adnanthadi ,
As @venal you need to select only the phase columns and then select the unpivot that should give expected result.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!