Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Conditional Formatting

I have data that is as follows. 

Name TeamsDisqualified
Name 1 Team A1
Name 1 Team B 

Name 1

 Team C1
Name 2 Team B 

Name 2

 Team D1
Name 2 Team E 
Name 3 Team F 
Name 3 Team C1
Name 4 Team D1
Name 4 Team G1
Name 4 Team C1

 

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

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

 

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

Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    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

     

     

1 Reply

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    3 years ago

    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