Conditional formatting - Multiple table dates

[Ricsta]

Hi!

I have in my report 3 tables that are based on the same dataset, but filtered differently. I wish to conditionally format either the background colour or the font colour based if the values in any of the tables are equal to eachother. See example:

All tables are comprised of three columns; 1. Name, 2. Phase, 3. Date

The three tables are filtered based on a fourth value. This value is one of three, either X, Y or Z. For table A, only conditions matching value X is shown. For table B, only conditions matching Y, etc. 

The thing is, the names, phases and dates may be equal across the tables, despite different values of X, Y or Z. I want to highlight these so that I don't get a collition of dates. (These are projects moving into new phases, with values X, Y and Z being gatekeepers. A project shouldn't pass multiple gatekeepers on the same date).

Is there a way to write a formula for conditional formatting based on if else? Note that I am not highly skilled in PBI.

E.g. if name and phase and date of value X equals name and phase and date of value Y then red background..... Or if the tables are differentiated, something like if table A equals table B then...

Remember, the dataset is the same across the tables.

Brg. 

Richard

[v-yuta-msft]

@Ricsta,

Yes, the logic can be realized in conditional formatting pane, click format pane of one visual then click conditional formatting, select rules like below:

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ricsta · Accepted solution]

Hi @v-yuta-msft, 

Thanks for the reply. I solved this problem in another manner, by implementing a calculated column and using Count = CALCULATE ( COUNT ( 'table'[column]); ALLEXCEPT ( 'table'; 'table'[column] ) ) and applying conditional formatting to results greater than 1 (duplicates of merged column so that it covers entire row).

Brg

Richard