Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
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!
Board | BoardID | PointofContact |
Board 1 | 1.1 | Sally Jones |
Board 2 | 2.1 | Mark Sanders |
Board 3 | 3.1 | Terri Moreau |
First Name | Last Name | Board | BoardID | MemberID | Flagged | FlagPoC |
George | Smith | Board 1 | 1.1 | 1 | FALSE | |
Mary | Jones | Board 2 | 2.1 | 2 | TRUE | Anne Hathaway |
Anush | Patel | Board 1 | 1.1 | 3 | FALSE | |
Vladimir | Ivanov | Board 3 | 3.1 | 4 | TRUE | Ryan Reynolds |
Gabriel | Mercier | Board 2 | 2.1 | 5 | TRUE | Jennifer Garner |
Amanda | Bridgerton | Board 1 | 1.1 | 6 | TRUE | Helen Mirren |
Solved! Go to Solution.
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:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@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!
Check out the May 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
73 | |
72 | |
70 | |
48 | |
45 |
User | Count |
---|---|
46 | |
38 | |
29 | |
28 | |
28 |