cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Lingaro Gantt Chart several milestones per project

Does anyone know of a way to show multiple milestones for one project? Currently, it simply mirrors the data structure, which is: 

 

Project             Milestone                   Date

x                       Sign contract             01-01-2021

x                       Start production        01-02-2021

y                       Project approval        01-04-2021

y                       Deliverable 1             01-05-2021

 

Tableau does this neatly where it automatically groups the projects and lists the deliverables for each project. Can Power BI something similar? 

 

I have tried Lingaro that shows it like this: 

RebeccaETE_1-1629351667370.png

 

 

I have also the Gantt 2.2.3 by Power BI (I believe it is) but it gets the milestones all wrong. 

RebeccaETE_0-1629351626706.png

 

Greatly appreciate any help with this 

 

Cheers, 

Rebecca

3 REPLIES 3
NicoleDavenport
New Member

Hi Rebecca, 

Been wrestling with this one myself and came across this article which works for Gantt 2.2.3 The trick to the getting the milestones to line up is to make sure you have both a start and end date in your row for the milestone, and no other dates (such as task start date) otherwise the visual picks up the first date it can find. 

Second thing to note is that your data will need repeating rows with the task name the same for each milestone, and then select the Group option (not Parent) as outlined in this post -that will line them up on the same row. 

Solved: Gantt Chart 2.2.0 milestones - Microsoft Power BI Community

Anonymous
Not applicable

Hi @VahidDM 

 

Thanks for your reply 

 

However, it doesn't really solve what I'm looking for. And it gets the milestone dates wrong. 

 

I've uploaded the work files and Power BI file here: https://www.dropbox.com/sh/8t4rkmanaza0lso/AACy-6HfTMKafATXs9NfVtDHa?dl=0 

 

What I'm looking for is something like the Lingaro view, but with the milestones grouped together per project and shown on the same bar. So there is only one bar per project. 

 

Does it make sense? Can you help? 

 

Cheers 

Rebecca

 

VahidDM
Community Champion
Community Champion

Hi @Anonymous 

 

In Gantt 2.2.3, Add Milestone column to the Task and Milestone, and Date Column to the Start Date.

If you want to group them by project, Add Project Column to the Parent.

Like this:

VahidDM_0-1629354486567.png

VahidDM_1-1629354503627.png

VahidDM_2-1629354602396.png

 

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

Appreciate your Kudos VahidDM_3-1629354615761.png !!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.