Forum Discussion

Camstr's avatar
Camstr
Helper I
1 year ago
Solved

Highlight 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...
Need Help
Show and Tell
Tips and Tricks
  • MFelix's avatar
    MFelix
    1 year ago

    Hi Camstr

     

    You don't need to add a new column to the visual, you just need to use the measure on the conditional formatting of one of the tt columns or on both. Select the measure on the conditional formatting rules.and set the value equal to 1

  • MFelix's avatar
    MFelix
    1 year ago

    Hi Camstr  try the following code..

     

    Registration check =IF( SELECTEDVALUE (Table[Registration Number 2]) <>BLANK() & & SELECTEDVALUE (Table[Registration Number 1]) <> SELECTEDVALUE (Table[Registration Number 2]), 1)

     

     

Camstr's avatar
Camstr
Helper I
1 year ago

MFelix if 'Registration Number 2' is blank then I do not want it to record a mismatch (i.e. 1).  How would I edit the measure to ignore blanks?  Thanks in advance.

Registration Check = IF(SELECTEDVALUE(Table[Registration Number 1]) <> SELECTEDVALUE(Table[Registration Number 2]), 1)

 

MFelix's avatar
MFelix
Super User
1 year ago

Hi Camstr  try the following code..

 

Registration check =IF( SELECTEDVALUE (Table[Registration Number 2]) <>BLANK() & & SELECTEDVALUE (Table[Registration Number 1]) <> SELECTEDVALUE (Table[Registration Number 2]), 1)