Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Jukie
Frequent Visitor

Custom Tooltip Values for each row of Table

Hello!  I've seen a number of postings around this and they have gotten me 90% of the way there.  Undoubtedly I am just mising something simple.

 

I have a table of board members (Member Table).  In order to limit the amount of data shown, I want the Point of Contact for that board (Board Table) and the Contact if they are flagged (Member Table) to appear in a tooltip.  I created a custom tooltip and it works great for the Flagged Contact in the Member table.  As I scroll over each row, it changes the name of the contact if it is flagged.  However, the Point of Contact for that Board does not... in the example it always remains Mark Sanders. The two tables are connected via BoardID, so I am unsure what I am missing. THANK YOU!

 

Jukie_0-1721629765692.png

Jukie_1-1721629798701.png

Jukie_2-1721629834016.png

BoardBoardIDPointofContact
Board 11.1Sally Jones
Board 22.1Mark Sanders
Board 33.1Terri Moreau

 

First NameLast NameBoardBoardIDMemberIDFlaggedFlagPoC
GeorgeSmithBoard 11.11FALSE 
MaryJonesBoard 22.12TRUEAnne Hathaway
AnushPatelBoard 11.13FALSE 
VladimirIvanovBoard 33.14TRUERyan Reynolds
GabrielMercierBoard 22.15TRUEJennifer Garner
AmandaBridgertonBoard 11.16TRUEHelen Mirren
1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @Jukie ,

 

Being this a 1 to many relationship the columns from the one table must always be used on the visualization so that the correct filter is applied.

 

I believe that in yoiur case you are using the Board from the Second table instead of the first one and that gives you the incorrect result:

 

MFelix_0-1721638785901.png

 

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

2 REPLIES 2
MFelix
Super User
Super User

Hi @Jukie ,

 

Being this a 1 to many relationship the columns from the one table must always be used on the visualization so that the correct filter is applied.

 

I believe that in yoiur case you are using the Board from the Second table instead of the first one and that gives you the incorrect result:

 

MFelix_0-1721638785901.png

 

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Jukie
Frequent Visitor

@MFelix Thank you very much!  That does indeed solve the issue in the test data.  I'm still struggling with it in my actual data which is a little more complicated, but it gives me a place to start and a reason for the issue!  I appreciate your time and the explanation as to why it was not working.  Very helpful!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.