cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
G0ggs
Helper I
Helper I

Identfying tasks in the Gantt chart which have obstacles to completion

Hello 

 

I would like to create a gantt chart which has simple blocks for tasks based on a start date and end date which I can do currently.

 

But I would also like to use conditional formatting that highlights the block red if there are barriers that are stopping the task being completed.

 

For example I have a pipework build project whereby the start and end date of the pipework build is known but I also have to pressure test the existing pipework and if it isn't tested or pressure test has failed it is a barrier to the overall pipework build being completed. 

 

I would like the gantt chart to highlight the block red if the pressure test is failed and highlight orange if the test is needed and green if passed. 

 

Is this possible with any of the gantt charts in PowerbI and if so how would I do it please?

 

G0ggs_0-1620534110158.png

 

Thanks,

Gordon 

 

3 REPLIES 3
G0ggs
Helper I
Helper I

Jihwan, thanks for the reply. 

 

 

Jihwan_Kim
Community Champion
Community Champion

Hi, @G0ggs 

Thank you for your feedback.

I tried to create it with the timeline, however, I could not show it using the sample. Because in the sample, most of the works showed less than 20 days and the earliest one started from a year ago and the latest one started recently. So, I was confused about how to show all of them in one timeline.

By date?

By month? or, by quarter?

I decided to show it by how many days were used, but I think you are not looking for this.

 

And I failed to understand how the second screenshot can be made by using the first screenshot.


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Best regards, JiHwan Kim

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

Jihwan_Kim
Community Champion
Community Champion

Hi, @G0ggs 

I am not sure whether I understood your question correctly.

Please check the below picture and the measure. (Sample pbix file's link is down below).

The below measure can be used in conditional formatting rules.

 

 Picture5.png

Pipework Duration =
VAR duration =
MAX ( Pipework[DateEnd] ) - MAX ( Pipework[DateStart] )
VAR pressuretestcondition =
SWITCH (
SELECTEDVALUE ( Pipework[Pipework pressure test] ),
"Failed/repair", 1,
"Needs tested", 2,
"Passed", 3
)
RETURN
COALESCE (
SWITCH (
TRUE (),
SELECTEDVALUE ( Days[Day] ) <= duration
&& pressuretestcondition = 1, 1,
SELECTEDVALUE ( Days[Day] ) <= duration
&& pressuretestcondition = 2, 2,
SELECTEDVALUE ( Days[Day] ) <= duration
&& pressuretestcondition = 3, 3
),
0
)
 
 
 
 

Hi, My name is Jihwan Kim.


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

 


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Best regards, JiHwan Kim

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors