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

 

Highlighted
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 Kudos Received Badges Coming

New Kudos Received Badges Coming

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

Microsoft Implementation for Communities Wins Award

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

Power Platform World Tour

Find out where you can attend!

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