Conditional Formatting Color on Rows - Matrix Table - Gantt Chart

[skyraptor]

Hello -

I'm working on creating a Gantt Chart and was able to leverage the one from @KerKol (thanks so much!)

I have a list of projects that are further defined into 3 different steps: Fieldwork, Planning, Reporting (Project Category). And I currently have it distinguished by different colors as below.

However - I would like to drill everything up (as below), but wanted to see if there was a way to keep the 3 distinguished colors, instead of the solid color line? I've been playing around with the conditional formatting, but haven't had success.

Link to Kerkol's Power BI file: https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/WoW-2022-Week-08-Gantt-Chart/m-p/2366... (I'm using the "Impossi-Puzzle" / 4 of 4 view)

[skyraptor]

This looks like it will work, much appreciated. Thank you!

[MFelix · Accepted solution]

Hi @skyraptor ,

For this you need to create a specific measure that considers the level at wich you are and use it on your condittional formatting:

Colour Formatting =
VAR temptable =
    FILTER (
        Projects,
        Projects[Start Date] <= MIN ( 'Calendar'[Date] )
            && Projects[End Date] >= MAX ( 'Calendar'[Date] )
    )
VAR categoryvalue =
    MAXX ( temptable, Projects[Project Category] )
VAR totalrows =
    COUNTROWS ( temptable )
RETURN
    SWITCH (
        TRUE (),
        totalrows = 1
            && categoryvalue = "FieldWork", "Red",
        totalrows = 1
            && categoryvalue = "Planning", "Blue",
        totalrows = 1
            && categoryvalue = "Reporting", "Yellow",
       "Green"
    )

For this metric to work with the individuals colour within each of the values you need to be sure that there is no overlap of dates  for each category, that is why I made the totalrows that checks if there is a single category value for each one, if there is more than one I return the green,

The measure needs to be updated for you specific usecase.