Conditional formatting based on column values

Hi,

Without knowing your data or seeing a sample, it will be difficult to come up with a solution. But below will be basics that may point you in the right direction.

First, create a measure that will return a Hex Color Value based on the condition you described. You will have to have to know the grouping of the table visual as well as an ordered column to uniquely identify the row. I simply created an Index column and have the table ordered by that column.

The logic of the measure will be to create a summary table. Then, iterate over the table to find the minimum value with the filter for ALLSELECTED and Measure 1 less than -5.

Finally, the measure will return a hex color if the minimum Index matches the visual's current row Index.

Measure 2 Bg Color = 
VAR minIndex =
    CALCULATE(
        MINX(
            SUMMARIZE(
                'Sample Data',
                'Sample Data'[Index]
            ),
            'Sample Data'[Index]
        ),
        FILTER(ALLSELECTED('Sample Data'), 'Sample Data'[Measure 1] < -5)
    )

RETURN
IF(
    minIndex = SELECTEDVALUE('Sample Data'[Index]),
    "#0000FF",
    "#FFFFFF"
)

Then, in the Visualizations pane for the Table visual you want this format applied to, click the down caret of the measure you want the formatting on, hover over Conditional formatting, and select Background color.

Finally, change Format stype to Field value. And select the measure created that returns the hex color in What field should we base this on?

Results: