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
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

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

Top Solution Authors
Top Kudoed Authors