Conditional Formatting

[Anonymous]

I have data that is as follows. 

Name		Teams	Disqualified
Name 1		Team A	1
Name 1		Team B
Name 1		Team C	1
Name 2		Team B
Name 2		Team D	1
Name 2		Team E
Name 3		Team F
Name 3		Team C	1
Name 4		Team D	1
Name 4		Team G	1
Name 4		Team C	1

I have a  tooltip table that highlights the following. I use the tooltip on another table to highlight the users and get their teams. 

Name	Teams
Name 1	Team A
Name 1	Team B
Name 1	Team C
Name 2	Team B
Name 2	Team D
Name 2	Team E
Name 3	Team F
Name 3	Team E
Name 4	Team G
Name 4	Team C

So how would one highlight on the tooltip NAme and show a Color Red for the teams that have been disqualified? 

[v-easonf-msft · Accepted solution]

Hi， @Anonymous 

You need duplicate a new table and establish relationship like below:

Then create tooltip page with data from new duplicate table.

Please check attached pbix for more details.

Best Regards,
Community Support Team _ Eason