Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Anonymous
Not applicable

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
Super User
Super User

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.