Conditional Formatting based on 2 columns

[Anonymous]

Problem Case: I have 2 columns in my table visual called A and B and they contain numeric values. I want to highlight the rows where value of Column A is not equal to value of Column B. How can I achieve this?

Thanks in advance!

[parry2k · Accepted solution]

@Anonymous you can add a measure to check this and assign the color code:

Color = 
VAR __ColA = SELECTEDVALUE ( Table[Col A] )
VAR __ColB = SELECTEDVALUE ( Table[Col B] )
RETURN
IF ( __ColA <> __ColB, "Red" )

Use above measure in the conditional formatting.