Forum Discussion

PowerBIspeed's avatar
PowerBIspeed
Frequent Visitor
4 years ago
Solved

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 m...
Need Help
  • arichard19's avatar
    arichard19
    4 years ago

    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 = ColumnDifference
    RETURN IF(Column Difference <> 0, "#40E0D0", "#FFA07A")

    Apply the measure as such ->
     

     


     

arichard19's avatar
arichard19
Resolver I
4 years ago

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 = ColumnDifference
RETURN IF(Column Difference <> 0, "#40E0D0", "#FFA07A")

Apply the measure as such ->