Conditional formatting per row in a table

[Luuud8080]

Hello everybody,

Hope you can maybe help me. I need to create a table with conditional formatting but rules per row can be different, i create this one as an example ot be clear.
Ex. There are categories where positive values are better (Exporta, produciotn, etc) , so bigger they are, greener they will be, lower > dark red

Some other, instead are better when they decrease so green should be for negative values and red if they grow (interest rates, unemployment, etc).

I created a measure for MoM%, but these way it's not possible to format row as I explained above.

Someone has some idea how to proceed?

Thank you very much in advance

[SamWiseOwl · Accepted solution]

Hi @Luuud8080 

When applying conditional formatting you can choose from: Gradient, Rules or Field Value.

The final option lets you use a measure as a formatter.

Right click your table and choose create measure.

Then create a measure using switch which lets you do multiple tests.

Colour measure =
Switch(
True()
,SelectedValue(table[column]) = "Industrial Production YoY" && [Measure] >= 0.5

,"Green" --If both conditions apply return green

,SelectedValue(table[column]) = "Industrial Production YoY" && [Measure] <0.5

,"Red" --If both conditions apply return red

,SelectedValue(table[column]) = "Jobless" && [Measure] <= 0.5

,"Green" --If both conditions apply return green

,SelectedValue(table[column]) = "Jobless" && [Measure] <= 0.5

,"Red" --If both conditions apply return green

)

Add as many rows as required, testing the current row and applying different conditions.