Conditional Formatting - Highlight Lowest Value(s)

Hi Anonymous 

In your case, you need to create a measure to help set the conditional formatting. I create a sample with some data and use below measure. The measure is to compare the lowest value with each value and return 1 when a value equals to the lowest value. Then format the values by Rules when color measure returns 1.

Color Measure = 
VAR _table =
    SUMMARIZE (
        FILTER (
            ALL ( 'Table' ),
            YEAR ( 'Table'[Date] ) = MAX ( DimDate[Year] )
                && MONTH ( 'Table'[Date] ) = MAX ( DimDate[Month] )
        ),
        'Table'[Location],
        "avg", [Avg.Value]
    )
VAR _minAvg = MINX ( _table, [avg] )
RETURN
    IF ( [Avg.Value] = _minAvg, 1, 0 )

Attach the pbix for your reference.

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.