Forum Discussion

ianhead's avatar
ianhead
New Member
4 years ago

Condtional formating one tables values based on differences with another

I have two large tables ingested eg Table A and Table B.
They come from the same source and have the same columns but are ingested a week apart. This results in occasional different values between them that are hard to spot and want to hghlight.
How do I conditionally format values in the Table A if its values are different from Table B?
Thanks in advance

Need Help
Tips and Tricks

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    ianhead , best if we can compare measures from those in visual like

     

    color =
    var _change =Sum(Table1[Value]) -Sum(Table2[Value])
    return
    SWITCH (
    TRUE(),
    _change > 0, "green",
    _change = 0, "blue",
    _change < 0, "red"
    )

     

    but these need to be plotted against a common dimension. And You use this measure in conditional formatting using the field value option

     

    Or if the exact same structure create a new table of diff

    intersect(A,B)

     

    • ianhead's avatar
      ianhead
      New Member
      4 years ago

      OR
      Can I make a new table by subtracting Table B from Table A? So each cell in the new table would show the difference between corresponding cells in Table A and B.
      I tried lots of different way but can't quite get the syntax right and not really understanding the errors I get.
      Thanks in advance 

  • ianhead's avatar
    ianhead
    New Member
    4 years ago

    Hi AmitChandak - thanks so much for having a look and suggesting your solution.  I am new to this more complicated side of Power Bi DAX coding.
    Your solution worked for me in part but not in another. Its probably best if I illustrate the outcome in the graphic below where I have anonymised all the data. And forgive me, I previously stated I was working with Tables, but in fact they are both Matrix visualisations:

    Thanks