Conditional formatting of table rows

[webportal]

Ok, I promise I'll never understand conditional formatting in Power BI...

I want to format the rows of a table if column "Churn" is equal to "Label" like:

If it is: green

If it is not: red.

I tried all possible combinations with calculated measures, columns, etc, etc, etc, but nothing works.

Is it possible at all to do this?

Thank you!

[Anonymous · Accepted solution]

Try to do the following, create a measure

"Color" = 

VAR S_Value = SELECTEDVALUE(Table[Column])

RETURN IF(S_Value = "Label", "#00FF00", "#FF0000")

Then, select the column, go to Conditional Formatting > Background color > Field Value >Based on field: Select the measure "Color". That should do it.

Note: #00FF00 is HEX code for green, #FF0000 for red. You can customize this by opening a color palette and retrieving the HEX code.

[webportal · Accepted solution]

@Anonymous 

Thanks for your help!

[Anonymous · Accepted solution]

Try to do the following, create a measure

"Color" = 

VAR S_Value = SELECTEDVALUE(Table[Column])

RETURN IF(S_Value = "Label", "#00FF00", "#FF0000")

Then, select the column, go to Conditional Formatting > Background color > Field Value >Based on field: Select the measure "Color". That should do it.

Note: #00FF00 is HEX code for green, #FF0000 for red. You can customize this by opening a color palette and retrieving the HEX code.