Forum Discussion
Conditional formating based on two columns in differant tables.
Hi,
I want rows to turn red when two columns in a report are not equal.
These are two columns wich are both in a dfferant table.
I tryed several things but its not working.
I doesnt matter for me if the whole row or just one cell in the row turns red.
Thank you in advance.
I would suggest trying following -
Create a measure where you substract Column[1] from Column[2]
-
Column Difference = Column[1] - Column[2]
-
Then, you will want to apply conditional formating based on the above Column Difference Measure.
If the Column Difference is different from 0, the conditional formatting should be red
-Colour Project =VAR Diff = ColumnDifferenceRETURN IF(Column Difference <> 0, "#40E0D0", "#FFA07A")
Apply the measure as such ->
3 Replies
I would suggest trying following -
Create a measure where you substract Column[1] from Column[2]
-
Column Difference = Column[1] - Column[2]
-
Then, you will want to apply conditional formating based on the above Column Difference Measure.
If the Column Difference is different from 0, the conditional formatting should be red
-Colour Project =VAR Diff = ColumnDifferenceRETURN IF(Column Difference <> 0, "#40E0D0", "#FFA07A")
Apply the measure as such ->Hi PowerBIspeed ,
Conditional formatting is relative to the field, if you want to change the color of the entire row, you need to apply conditional formatting to all fields.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
arichard19 This was the most usable solution for me. Thanks for this.
