Conditional Formatting on Matrix based on same measure comparison

Thanks for the reply from lbendlin, please allow me to provide another insight.
Hi mikeminu ,

Please refers to the following steps.

Below is my testing data table.

Create a date table and establish a relationship with the source table.

DimDate = ADDCOLUMNS(
    CALENDAR(MIN('Table'[Date]),MAX('Table'[Date])),
    "Year", YEAR([Date])
)

Use the following measure to set the conditional format of the matrix values.

Measure = 
VAR SelectedYear = SELECTEDVALUE(DimDate[Year])

VAR CurrentYearValue = CALCULATE([Sum of price], DimDate[Year]=SelectedYear)
VAR PreviousYearValue = CALCULATE([Sum of price], DimDate[Year]= SelectedYear-1)
RETURN
SWITCH(
    TRUE(),
    CurrentYearValue>PreviousYearValue,1,
    CurrentYearValue<PreviousYearValue,-1,
    0
)

The final result is as follows. Hopefully it will meet your needs.

Please see the attached pbix for reference.

Best Regards,
Dengliang Li

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