cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

How to Create Gantt Chart Visual With Multiple Milestones On One Line?

Suppose I have the following data structure (from an Excel file but I guess this doesn't really matter here)

NameMS1MS2MS3
Task 115.03.202130.06.202130.10.2021
Task 201.02.202101.04.202131.08.2021
Task 301.02.202130.06.202115.09.2021

 

I would like to create a visual as a gantt chart that

  • uses a free PowerBI visual (e.g. Gantt or Gantt Chart by MAQ)
  • shows one "line" in the gantt per Task 1, Task 2, Task 3
  • on each "line" shows three milestones for MS1, MS2, MS3 with the dates given in the table
  • each milestone has a color (or icon or whatever) according to its "category" (e.g. all MS1 are green, all MS2 are red)

I am of course happy to transform the data in any way needed. 

However so far I am simply not able to get it to work. Can't figure out the right data format and / or which data to put into which fields of the above mentioned visuals. Also this date hierachy puzzles me - in some attempts, when at least showing some milestones (never more than one per line) I usually end up with "earliest date" for those...

 

If all fails I would also accept to have each milestone on a single line grouped by the Task name.

 

Any hints would be appreciated. 

 

Edit: not sure why the table layout is messed up like this, should look like this

janitor048_0-1606346485907.png

 

1 ACCEPTED SOLUTION
Super User IV
Super User IV

Please check out the As Timeline visual.  I unpivoted your data and tried that.  Key thing is to uncheck the Stacked option in the formatting options.

 

mahoneypat_0-1606350966879.png

 

Regards,

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

3 REPLIES 3
Helper I
Helper I

@mahoneypat @Ashish_Mathur thanks for your replies! Unpivot of my table indeed did the trick, especially together with the "As Timeline" visual.

Super User IV
Super User IV

Please check out the As Timeline visual.  I unpivoted your data and tried that.  Key thing is to uncheck the Stacked option in the formatting options.

 

mahoneypat_0-1606350966879.png

 

Regards,

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

Super User III
Super User III

Hi,

In the Query Editor, right click on the Name column and select "Unpivot other columns".

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors