cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Ricsta Frequent Visitor
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
Ricsta Frequent Visitor
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

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Conditional formatting - Multiple table dates

@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:

Capture.PNG 

 

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 Frequent Visitor
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

View solution in original post

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)