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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
saturation
Frequent Visitor

N:N Relationships with Intersect entity not showing proper data in visual

I have 3 tables in Power Query Editor that have the relationships setup correctly in the model area. There are 3 tables:

 

1) Activity

2) ActivityPerson (Intersect Entity)

3) Person

 

I am trying to display, for example

 

id     Activity | Person

1      went to mall     |   Mike Smith

2      went to mall     |   John Doe

 

The ActivityPerson stores the activityid and the personid only, no other fields. However, when I create my visualizations, they don't seem to be displaying the proper setup. I.e., if I have a Table visualizer for people and Activity Slicer, it doesn't filter down to the right people. Any ideas what's going on here?

2 REPLIES 2
Anonymous
Not applicable

Can you upload some sample data?  onedrive works well

I can't post to OneDrive, but I extracted some data and changed the names, etc....Let me know if this works.

ActivityCode

nameactivitycodeid
Auction - 2014ce20e09a-f68b-e911-a827-000d3a3150b6
Auction - 2015cf20e09a-f68b-e911-a827-000d3a3150b6
Auction - 2016d020e09a-f68b-e911-a827-000d3a3150b6

 

Intersect Entity

contact_activitycodeidcontactidactivitycodeid
d75e249b-2f8c-e911-a827-000d3a3150b668890cc0-138c-e911-a827-000d3a3150b6ce20e09a-f68b-e911-a827-000d3a3150b6
d85e249b-2f8c-e911-a827-000d3a3150b66f890cc0-138c-e911-a827-000d3a3150b6ce20e09a-f68b-e911-a827-000d3a3150b6
db5e249b-2f8c-e911-a827-000d3a3150b6e9890cc0-138c-e911-a827-000d3a3150b6ce20e09a-f68b-e911-a827-000d3a3150b6
df5e249b-2f8c-e911-a827-000d3a3150b668890cc0-138c-e911-a827-000d3a3150b6cf20e09a-f68b-e911-a827-000d3a3150b6
e35e249b-2f8c-e911-a827-000d3a3150b6e9890cc0-138c-e911-a827-000d3a3150b6cf20e09a-f68b-e911-a827-000d3a3150b6
e45e249b-2f8c-e911-a827-000d3a3150b668890cc0-138c-e911-a827-000d3a3150b6d020e09a-f68b-e911-a827-000d3a3150b6
e65e249b-2f8c-e911-a827-000d3a3150b66f890cc0-138c-e911-a827-000d3a3150b6d020e09a-f68b-e911-a827-000d3a3150b6
e95e249b-2f8c-e911-a827-000d3a3150b6e9890cc0-138c-e911-a827-000d3a3150b6d020e09a-f68b-e911-a827-000d3a3150b6

 

Contact

contactidfirstnamelastname
68890cc0-138c-e911-a827-000d3a3150b6JackLopes
6f890cc0-138c-e911-a827-000d3a3150b6AlexCooper
e9890cc0-138c-e911-a827-000d3a3150b6MonicaSmith

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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