Matrix value columns Conditional Formatting

[Anonymous]

Hi All,

I am looking for some help with conditional formatting; i have created a training matrix that requires the status column to be orange if the training completed date has been completed and the re-audit date is blank, and if both the training completed date and Re-audit date is populated then the status should turn green.

This is how my columns look in the matrix table:

Thank you

[mwegener]

Hi @Anonymous ,

can you provide an example PBIX?

[Anonymous]

Hi @mwegener,

Please find an example pbix file: https://1drv.ms/u/s!AqpscUO4vhcRkgmpWKu5Wt-ET72b?e=zVyx33

Thank you

[mwegener · Accepted solution]

Hi @Anonymous ,

try the following measure for formatting.

CF =
IF (
    MIN ( 'Training Records'[DateTrainingCompleted] ) <> BLANK ()
        && MIN ( 'Audit Record'[Re Audit Date] ) = BLANK (),
    "#E66C37",
    IF (
        MIN ( 'Training Records'[DateTrainingCompleted] ) <> BLANK ()
            && MIN ( 'Audit Record'[Re Audit Date] ) <> BLANK (),
        "#00FF00",
        BLANK ()
    )
)

[Anonymous]

Hi @mwegener ,

That worked perfectly! 

Thank you