Color data that has been changed in Power BI

Hi Anonymous ,

According to your description, here's my solution. Create five measures.

result_color =
VAR _previous =
    MAXX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[car_id] = MAX ( 'Table'[car_id] )
                && 'Table'[date] < MAX ( 'Table'[date] )
        ),
        'Table'[result]
    )
RETURN
    IF (
        MAX ( 'Table'[result] ) <> _previous
            && _previous <> BLANK (),
        "light green"
    )

status_color =
VAR _previous =
    MAXX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[car_id] = MAX ( 'Table'[car_id] )
                && 'Table'[date] < MAX ( 'Table'[date] )
        ),
        'Table'[status]
    )
RETURN
    IF (
        MAX ( 'Table'[status] ) <> _previous
            && _previous <> BLANK (),
        "light green"
    )

date_color =
VAR _previous =
    MAXX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[car_id] = MAX ( 'Table'[car_id] )
                && 'Table'[date] < MAX ( 'Table'[date] )
        ),
        'Table'[date]
    )
RETURN
    IF (
        MAX ( 'Table'[date] ) <> _previous
            && _previous <> BLANK (),
        "light green"
    )

carvalue_color =
VAR _previous =
    MAXX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[car_id] = MAX ( 'Table'[car_id] )
                && 'Table'[date] < MAX ( 'Table'[date] )
        ),
        'Table'[car_value]
    )
RETURN
    IF ( MAX ( 'Table'[car_value] ) <> _previous, "light green" )

newcar_color =
VAR _previous =
    MAXX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[car_id] = MAX ( 'Table'[car_id] )
                && 'Table'[date] < MAX ( 'Table'[date] )
        ),
        'Table'[new_car_value]
    )
RETURN
    IF (
        MAX ( 'Table'[new_car_value] ) <> _previous
            && _previous <> BLANK ()
            && MAX ( 'Table'[new_car_value] ) <> BLANK (),
        "light green"
    )

In visualizations formatting pane>Cell elements, select the columns in the Series and turn on the backgroud color option.

Select corresponding measure in the dislog.

Get the correct result:

I attach my sample below for your reference.

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

Best regards,

Community Support Team_yanjiang