Creating a measure to conditionally format a matrix

[kimchizal]

I'm struggling to figure out how to create a measure to conditionally format a matrix. Here's a picture of my matrix:

I"d like to color code all 3 columns under the post group, so that if the value is greater than the corresponding value in the 'Pre' group, then color code green, otherwise color code red

I have my data in a long format rather than wide, so I'm not sure how to go about creating the DAX measure to do this. Here's a sample of it:

[v-jiascu-msft]

Hi @kimchizal,

Could you please mark the proper answers as solutions?

Best Regards,

[kimchizal]

Here's a link to the data: removed

[v-jiascu-msft · Accepted solution]

Hi @kimchizal,

Please download the demo from the attachment. Please also refer to power-bi/desktop-conditional-table-formatting.

formatMeasure =
VAR postValue =
    CALCULATE (
        [Program(s)],
        FILTER ( ALL ( Sheet3[prepost] ), Sheet3[prepost] = "Post" )
    )
VAR preValue =
    CALCULATE (
        [Program(s)],
        FILTER ( ALL ( Sheet3[prepost] ), Sheet3[prepost] = "Pre" )
    )
RETURN
    IF ( postValue > preValue, 1, 0 )

BTW, please don't share sensitive data here.

Best Regards,