Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have 4 data sheets in excel - Company, Country, Product and Industry. There is a primary key company ID which maps with all 3 tables. I have created a pivot table using these 4 sheets and multiple slicers for industry, country etc.
The slicers are not filtering records in the pivot table. Even though I have created relationships between the tables using primary key and foreign key. Is there anything I am missing here? The slicers are from columns in 3 tables country, product and industry.
Hi @gunjan3 ,
Could you please mark the proper answers as solutions?
Best Regards,
Hi @gunjan3,
Can you share a sample? Please mask the sensitive parts. At least share some snapshots.
The possible cause the "Cross filter direction". Please refer to the snapshot below.
Best Regards,
User | Count |
---|---|
102 | |
91 | |
87 | |
78 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |