Forum Discussion
Conditional Formatting based on 2 columns
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!
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.
1 Reply
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.