cancel
Showing results for
Did you mean:
Frequent Visitor

## Conditional formatting - Multiple table dates

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

## Re: Conditional formatting - Multiple table dates

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

2 REPLIES 2
Community Support Team

## Re: Conditional formatting - Multiple table dates

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.

Highlighted
Frequent Visitor

## Re: Conditional formatting - Multiple table dates

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

Announcements

Kudos to you if you earned one of these! Check your inbox for a notification.

#### Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (1,993)