Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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
name | activitycodeid |
Auction - 2014 | ce20e09a-f68b-e911-a827-000d3a3150b6 |
Auction - 2015 | cf20e09a-f68b-e911-a827-000d3a3150b6 |
Auction - 2016 | d020e09a-f68b-e911-a827-000d3a3150b6 |
Intersect Entity
contact_activitycodeid | contactid | activitycodeid |
d75e249b-2f8c-e911-a827-000d3a3150b6 | 68890cc0-138c-e911-a827-000d3a3150b6 | ce20e09a-f68b-e911-a827-000d3a3150b6 |
d85e249b-2f8c-e911-a827-000d3a3150b6 | 6f890cc0-138c-e911-a827-000d3a3150b6 | ce20e09a-f68b-e911-a827-000d3a3150b6 |
db5e249b-2f8c-e911-a827-000d3a3150b6 | e9890cc0-138c-e911-a827-000d3a3150b6 | ce20e09a-f68b-e911-a827-000d3a3150b6 |
df5e249b-2f8c-e911-a827-000d3a3150b6 | 68890cc0-138c-e911-a827-000d3a3150b6 | cf20e09a-f68b-e911-a827-000d3a3150b6 |
e35e249b-2f8c-e911-a827-000d3a3150b6 | e9890cc0-138c-e911-a827-000d3a3150b6 | cf20e09a-f68b-e911-a827-000d3a3150b6 |
e45e249b-2f8c-e911-a827-000d3a3150b6 | 68890cc0-138c-e911-a827-000d3a3150b6 | d020e09a-f68b-e911-a827-000d3a3150b6 |
e65e249b-2f8c-e911-a827-000d3a3150b6 | 6f890cc0-138c-e911-a827-000d3a3150b6 | d020e09a-f68b-e911-a827-000d3a3150b6 |
e95e249b-2f8c-e911-a827-000d3a3150b6 | e9890cc0-138c-e911-a827-000d3a3150b6 | d020e09a-f68b-e911-a827-000d3a3150b6 |
Contact
contactid | firstname | lastname |
68890cc0-138c-e911-a827-000d3a3150b6 | Jack | Lopes |
6f890cc0-138c-e911-a827-000d3a3150b6 | Alex | Cooper |
e9890cc0-138c-e911-a827-000d3a3150b6 | Monica | Smith |
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |