Project Progress Timeline/Gantt with phases and milestones

[BHpowerbi]

Hi,

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

My data is structured in the following way:

Name	Start	Progress Phase 1	Delay Phase 1	Milestone 1	Progress Phase 2	Delay Phase 2	Milestone 2	Progress Phase 3	Delay Phase 3	Finish
Project 1	1/1/20	5	3	1/9/20	3	1	1/13/20	6	2	1/21/20
Project 2	1/5/20	4	10	1/19/20	3	0	1/23/20	7	0	1/29/20
Project 3	1/10/20	5	0	1/125/20	4	0	1/19/20	6	0	1/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

[ahsankhan]

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

[Anonymous]

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]

@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]

which charts have you tried?

can you share some dummy data?

[BHpowerbi]

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