Can Power BI search in one data to look for similar data in another data, then highlight that data

[WheelchairWilly]

I want Power BI to look in GW02 data and if it finds any names that are the same that are listed in Picked Players data

then highlight that name in Picked Player. 

[DataVitalizer · Accepted solution]

@WheelchairWilly Here are the steps to follow 

1. Create a new column in table 'Bav Team'

Compared = IF(CONTAINS('Goal Scorers', 'Goal Scorers'[Goal], 'Bav Team'[Goals]), "Y", "N")

 2. Apply the conditional formattion 

Did it work ?  ‌‌👍 A kudos would be appreciated 📢 Mark it as a solution to help spreading 

[v-binbinyu-msft]

Hi @WheelchairWilly ,

Please try below steps:

1. below is my test table

Bav Team:

Goal Scorers:

2. create a measure with below dax formula

Measure =
VAR _str =
    CONCATENATEX ( 'Goal Scorers', [GW02], "," )
VAR cur_pp =
    SELECTEDVALUE ( 'Bav Team'[Picked Players] )
VAR _val =
    IF ( CONTAINSSTRING ( _str, cur_pp ), "Blue" )
RETURN
    _val

3. add a table visual with Bav Team fields, and set the conditional formatting

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[WheelchairWilly]

Can you send me a link so I can send on my file.

[DataVitalizer]

Hi @WheelchairWilly 

1. Create a relationship between tables

2. Create a new column in 'Bav Team'

Compared = IF(RELATED('Goal Scorers'[GW02])='Bav Team'[Picked Players],"Y","N")

3. Apply a conditional formatting / Background coloe on the table visual

Did it work ?  ‌‌ Mark it as a solution to help spreading knowledge, 
📢 Don't forget a kudos 👍 would be appreciated

[WheelchairWilly]

Hi, This is what I'm getting when I ENTER YOUR CODE.

[DataVitalizer]

Could you share the pbix file?

Did it work ?  ‌‌ Mark it as a solution to help spreading knowledge
Was this exchange helpful? A kudos 👍 would be appreciated

[WheelchairWilly]

https://1drv.ms/u/s!AiLxwPYo48O5gvw0zWuO7-2dd8p09A?e=9Ad2pE

https://1drv.ms/x/s!AiLxwPYo48O5gvwsi3FklLJykb0xng?e=UubUdY

Hope this works.  

[DataVitalizer]

Both links got got blocked, could you share a public link?

[DataVitalizer]

@WheelchairWilly  you can use this service https://wetransfer.com/

[WheelchairWilly]

https://we.tl/t-7IuHfuBsY6

[WheelchairWilly]

https://we.tl/t-HnppaALvSi

[WheelchairWilly]

I've sent both files. How do you pick these up without me having your email?

[WheelchairWilly]

https://we.tl/t-HnppaALvSi

[DataVitalizer]

Hi @WheelchairWilly 
I could open the file, I will get this work done, afterwards, I will get back to you.

[DataVitalizer · Accepted solution]

@WheelchairWilly Here are the steps to follow 

1. Create a new column in table 'Bav Team'

Compared = IF(CONTAINS('Goal Scorers', 'Goal Scorers'[Goal], 'Bav Team'[Goals]), "Y", "N")

 2. Apply the conditional formattion 

Did it work ?  ‌‌👍 A kudos would be appreciated 📢 Mark it as a solution to help spreading 

[WheelchairWilly · Accepted solution]

Worked a treat. Many thanks for your effords.

[DataVitalizer]

I am glad I was able to help

[WheelchairWilly]

othy_bi, Can I ask you how would I see each GW01 right through to GW38, ie if I click GW21 I would see the totals for that GW and only that GW.  I seem yo be getting the total of everything when I click on any of the GW's you can see on my screenshot. (What you see are made up by me-so dont worry if you change things) 

[DataVitalizer]

@WheelchairWilly if you don't mind being more specific, I can see now what you have in your report, can you explain what you want to dispay/calculate instead?

[WheelchairWilly]

This file  is how I would like Power BI to look. https://we.tl/t-WhXtjU5ACz

[DataVitalizer]

Hi @WheelchairWilly 

I am trying to recreate the table visual you have, what is the relationship between both tables?