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
BHpowerbi
New Member

Project Progress Timeline/Gantt with phases and milestones

Hi,

 

I've been trying to create the following timeline, but I cannot find the correct visual to use that fills my needs:

progress.png

 

 

 

 

My data is structured in the following way:

NameStartProgress Phase 1Delay Phase 1Milestone 1Progress Phase 2Delay Phase 2Milestone 2Progress Phase 3Delay Phase 3Finish
Project 11/1/20531/9/20311/13/20621/21/20
Project 21/5/204101/19/20301/23/20701/29/20
Project 31/10/20501/125/20401/19/20601/25/20

etc (600+ lines)

 

These are my requirements:

  • Can process the data as provided above (column calculations allowed, but not changing the structure of the data source)
  • Color formatting of the various phases
  • Optional: show milestones specifically

 

Does anyone know a visual I can use to achieve this?

 

Thank you in advance!

 

Kind regards,

BH

5 REPLIES 5
ahsankhan
Helper I
Helper I

Hello There, 

Just wondering if you managed to get a solution to your problem. I am having a similar kind of dataset and using Adwise Visual, however, it is not plotting my Milestones. Please do share if you have any possible solution. 

Best Regards


Ghuiles
Advocate IV
Advocate IV

Additional info:

- Adwise Gantt chart is looking promissing https://www.adwise.cz/adwise-roadmap/?lang=en 

-  xViz is not for free for companies (120€/user/year, min 5 users)

- As Timeline do not have fancy marks for milestones

- So far a saw, only the MAQ Gantt allows that when a line is selected in the chart, that this line is filtering other items on the page.

amitchandak
Super User
Super User

@BHpowerbi , you have few project visual  or matrix with same conditional formatting for both fond and background

https://appsource.microsoft.com/en/product/power-bi-visuals/WA104380765?tab=Overview
https://www.mpug.com/articles/how-to-create-an-amazing-gantt-chart-in-power-bi/
https://blog.pragmaticworks.com/power-bi-custom-visuals-as-timeline
https://www.youtube.com/watch?v=SO4mk1H94OA
https://xviz.com/visuals/gantt-chart/

 

Create a color measure

Color  = if(FIRSTNONBLANK(Table[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170 
,"lightgreen",if(FIRSTNONBLANK(Table[Year],2014)>2018,"red","yellow"))
Color sales = if([Sales Today] -[sales yesterday]>0,"green","red")

color =
switch ( true(),
FIRSTNONBLANK(Table[commodity],"NA") ="commodity1" && sum(Table[Value]) >500,"lightgreen",
FIRSTNONBLANK(Table[commodity],"NA") ="commodity2" && sum(Table[Value]) >1000,"lightgreen",
/// Add more conditions
"red"
)

 

And use with conditional formatting "Field value" option

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

vanessafvg
Super User
Super User

which charts have you tried?

 

can you share some dummy data?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




I have tried the following visuals:

  • Gantt : only 1 start, 1 end, and progress - no breakdown for phases available
  • as Timeline : only 1 start and 1 end date - no breakdown for phases available
  • GANTT Chart by Lingaro : multiple segments, no color formatting of these segments
  • Gantt Chart - xViz : only 1 start and 1 end date - no breakdown for phases available

An example data set is provided here:

https://docs.google.com/spreadsheets/d/1r13KHszY2OOhqD2YjO95R9csTW4k3FxAAizhE18J_8k/edit?usp=sharing 

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.