Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |