Forum Discussion

DJBAJG's avatar
DJBAJG
Helper IV
4 years ago

Conditional Formatting.... Maybe???

Hi Team

 

I've got a question that, as you can see based on my title, may indeed be answered by using conditional formatting but I'm not sure as I haven't been able to get it to work. What I'm attempting to do is highlight, or otherwise call out a value in a row of a matrix if it appears as a row of another matrix. Both of these matrix visuals are on the same report. There's no way to uniquely identify them other than that they are in two different visuals, or at least I can't think of a way.

 

To add to the difficulty, the complexity and size of my real dataset does not allow for the addition of custom columns to the raw data so any solution of that nature is out. I've included a link to my working .pbix file. In this example the ID beginning with "6D5A0..." would be highlighted if we can find a solution.

 

As always thanks for any help you can provide.

 

https://drive.google.com/file/d/1L3WaBArW2dCOA7jY8vVwdWHYh1ARcrfD/view?usp=sharing 

 

 

Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    DJBAJG , Create a measure like , hope Id is used in visual

     

    Switch(true() ,

    left(max(Table[ID]) ,5) = "6D5A0" , "Green" ,

    "White"

    )

     

    Use in conditional formatting using field value option 

    • DJBAJG's avatar
      DJBAJG
      Helper IV
      4 years ago

      Hi amitchandak

       

      Thanks for the quick reply. Perhaps I didn't give enough detail. The solution must by dynamic. Any and all IDs that appear in matrix 1 and matrix 2 must be highlighted. A hard-coded measure will not achieve that.

      Thanks.

      • DJBAJG's avatar
        DJBAJG
        Helper IV
        4 years ago

        Hi Team

         

        Still looking for some help on this one. Any suggestions or advice are appreciated.

         

        Thanks.