cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
adnanthadi Frequent Visitor
Frequent Visitor

how to create Gantt chart with dates in columns not rows

Hi

i have a table with one column having project id's and 3 columns having dates of phases :

 

Project IDsPhase 1 DatePhase 2 DatePhase 3 Date
Project 112/1/201912/2/201912/4/2019
Project 212/4/201912/7/201912/9/2019
Project 314/1/201914/2/201914/4/2019

 

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..

1 ACCEPTED SOLUTION

Accepted Solutions
venal Senior Member
Senior Member

Re: how to create Gantt chart with dates in columns not rows

@adnanthadi 

I tried to re-pro the issue from my end and got the below.

unpivot-testing.JPG

 

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 more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

 

 

View solution in original post

4 REPLIES 4
Super User
Super User

Re: how to create Gantt chart with dates in columns not rows

Hi @adnanthadi,

I have posted a post for making a gaant chart may help you.

https://community.powerbi.com/t5/Community-Blog/Think-inside-the-box-Custom-visuals-using-Standard-V...

Also you need to unpivot your columns, to apply the option on the post.

Regards,
MFelix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




adnanthadi Frequent Visitor
Frequent Visitor

Re: how to create Gantt chart with dates in columns not rows

Hi MFelix,

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: 

TaskUserStart Date
Project 1Phase1 Date29-11-18
Project 1Phase2 Date14-05-19
Project 1Phase3 Date17-05-19
Project 2Phase1 Date14-01-19
Project 2Phase2 Date15-01-19
Project 2Phase3 Date23-05-19
Project 3Phase1 Date10-01-19
Project 3Phase2 Date10-01-19
Project 3Phase3 Date10-01-19

 

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

2018-11-292019-05-142019-05-17Project IDProject 1
2019-01-142019-01-152019-05-23Project IDProject 2
2019-01-102019-01-102019-01-10Project IDProject 3
2018-12-222019-02-082019-01-30Project IDProject 4
2019-05-032019-05-032019-05-24Project IDProject 5
venal Senior Member
Senior Member

Re: how to create Gantt chart with dates in columns not rows

@adnanthadi 

I tried to re-pro the issue from my end and got the below.

unpivot-testing.JPG

 

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 more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

 

 

View solution in original post

Super User
Super User

Re: how to create Gantt chart with dates in columns not rows

Hi @adnanthadi ,

 

As @venal  you need to select only the phase columns and then select the unpivot that should give expected result.

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,313)