detriez
Board Regular
- Joined
- Sep 13, 2011
- Messages
- 193
- Office Version
- 365
- Platform
- Windows
I just started using models/Power Pivot.
I'm trying to get my slicers to filter all my Pivot Tables.
My table is a flat file with companies and people associated with the companies
I have 5 Pivot Tables all from the same one table model
Three pivot tables count the distinct values of companies and two count the people
When I add a slicer and then select by clicking the checkbox for each table under report connections I want to control.
After clicking Ok to save, the slicer only filters the pivot table that was selected to create the slicer.
Opening the Report Connections reveals the checkboxes have been cleared except for the original one
I'm trying to get my slicers to filter all my Pivot Tables.
My table is a flat file with companies and people associated with the companies
I have 5 Pivot Tables all from the same one table model
Three pivot tables count the distinct values of companies and two count the people
When I add a slicer and then select by clicking the checkbox for each table under report connections I want to control.
After clicking Ok to save, the slicer only filters the pivot table that was selected to create the slicer.
Opening the Report Connections reveals the checkboxes have been cleared except for the original one
