Conditional formatting using a value who change every year

According to your description, I create a sample.

Here's my solution.

1. Create a KPI table, don't make relationship between the two tables.

2. Create a measure.

Color =
IF (
    MAX ( 'Table'[Score] )
        >= MAXX (
            FILTER (
                ALL ( 'KPI BY YEAR' ),
                'KPI BY YEAR'[Year] = YEAR ( SELECTEDVALUE ( 'Table'[Date] ) )
            ),
            'KPI BY YEAR'[KPI]
        ),
    "Blue",
    "Grey"
)

3. Select the stacked colum chart, in the Format pane, select Columns>Colors>fx, select the color measure in the dialog.

Get the correct result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.