How to highlight every new high max value

Hi,

I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your datamodel.

Weight measure: = 
SUM( Customer_weight[Weights] )

Color condition measure: =
VAR _maxvalueuptocurrentmonth =
    CALCULATE (
        MAX ( Customer_weight[Weights] ),
        WINDOW (
            1,
            ABS,
            0,
            REL,
            ALL ( 'Calendar'[Year-Month sort], 'Calendar'[Year-Month] ),
            ORDERBY ( 'Calendar'[Year-Month sort], ASC )
        )
    )
RETURN
    IF ( [Weight measure:] = _maxvalueuptocurrentmonth, "Red" )