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

[janitor048]

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

Name	MS1	MS2	MS3
Task 1	15.03.2021	30.06.2021	30.10.2021
Task 2	01.02.2021	01.04.2021	31.08.2021
Task 3	01.02.2021	30.06.2021	15.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]

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

[mahoneypat · Accepted solution]

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.

Regards,

Pat

[Ashish_Mathur]

Hi,

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

Hope this helps.