Forum Discussion
Excel Slicers on data model
Hi, looking for help. I have a couple of tables linked through a survey respondent ID in excel. I can't have the data in the same table because table 1 is the original table with one ID per row, and ...
Aren't slicer connections limited to pivot tables? So if you have a pivot chart, the slicer should be connected to its underlying pivot table.
thank you yes good point, although still, the pivot table name that the pivot chart is connected to does not appear in the slicers 'report connections' list?
- That means that the pivot table in question is either
1. Not tied to the data model
2. Not based on the same pivot cache as the other pivot table- Hi, thank you. How do I ensure then that the table is linked to the data model? I can see there is a relationship established between the two tables through the ID. I am not sure what you mean about pivot cache also, I will have a research
- Roughly speaking, there are two types of pivot tables:
1. Tied to a range directly (classic)
2. Tied to the data model
When you insert a new pivot table, the dialog has a "Data model" checkbox with the obvious effect!