Conditional Formatting.... Maybe???

[DJBAJG]

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 

[amitchandak]

@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]

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]

Hi Team

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

Thanks. 

[DJBAJG]

Anyone got any ideas? 

[DJBAJG]

Happy Monday. Still struggling with this one...