Conditional Formatting based on three text fields

[Anonymous]

Hi,

I am validating data from 3 different systems. I want to make a table like the example below where I can see for each row in the dimension where they are different, like:

- Which one is different from the other two

- If all three are dfferent

See below for example:

(the Date in SystemX is a text field)

I hope someone can help or give inspiration 🙂

[CNENFRNL]

Fairly simple task in Excel,

[Anonymous]

Hi,

The Excel I posted was just an example of how I wanted it to look like.

Do you have an idea to replicate that in PowerBI?

[Anonymous]

Hey Xilitor!

I was thinking of creating an extra column where you determine if:
 - Column 1 is different then 2 and 3
- Column 2 is different then 1 and 3
- Column 3 is different then 1 and 2
- All columns are different.

Then, based on that new column you can apply conditional formatting. 

Is this something you can work with?

[Anonymous]

Can you elaborate a bit more on that?

[Anonymous · Accepted solution]

Yes I can,

I have added three columns to determine if an column should get a background color. 

These are the formulas:

conditional1 = if(and(Example[System1]<>Example[System2],Example[System1]<>Example[System3]),1,0)

conditional2 = if(and(Example[System2]<>Example[System1],Example[System2]<>Example[System3]),1,0)

conditional3 = if(and(Example[System3]<>Example[System1],Example[System3]<>Example[System2]),1,0)

It gives you the following result:

If a conditional 1 is 1 then you can choose a background color for system 1 etc.

[Anonymous]

Thank you! It works! 🙂