Identfying tasks in the Gantt chart which have obstacles to completion

[G0ggs]

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?

Thanks,

Gordon 

[G0ggs]

Jihwan, thanks for the reply. 

[Jihwan_Kim]

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.

[Jihwan_Kim]

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.

 

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

)

https://www.dropbox.com/s/4s9ospqcmhrf5so/goggs.pbix?dl=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