Compare two columns in two tables and put a background color if does not match

[kmilarov]

Guys, I have two tables:

Table 1 with columns A, B, C

Table 2 with columns D, E, F

all are text.

And a visualization table listing columns A,B,C,D. 

I need to compare columns C and D and if do not match - to set a background color in this cell in column C.

Both tables are related via indirect relationship.

Thanks 🙂

[parry2k]

@kmilarov can you share how these tables are related? What you are referring to indirect relationship. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[kmilarov]

I have 7 tables in the repot. Table 1 is linked to table 3, table 3 to table 5 , table 5 to table 2. (Different columns and data).  That is why PBI sows a message that I cannot link / relate table 1 to table 2 directly since their is a indirect relation. 
But for the the comparison I need  - let's consider both tables are not linked / related.