Forum Discussion
Camstr
Helper I
Helper IHighlight where text data is not matching
Hello, Please see attached screenshot. I'd like to compare text from two different data sources and conditionally format to highlight where data does not match exactly. I would prefer not to intro...
MFelix
Super User
Super UserHi Camstr ,
Is the information stored in the same table or are you having the data in different tables? how is the information related?
If you have any kind of relationship between both of them and you are using it in a visual you can add a measure similar to this:
Registration Check = IF(SELECTEDVALUE(Table[Registration Number 1]) <> SELECTEDVALUE(Table[Registration Number 2]), 1)Now add a condittional formatting rule were this measure equals 1 to get the background or text in a red or other colour.
CamstrHelper I
Helper IHi Miguel, that's awesome thank you!
The data is stored in different tables and is related through another common identifier.
Your solution works nicely, but it does mean an extra column in my table (for the measure).
I guess that is unavoidable in PBI for text?
Cam