Forum Discussion
Slicer affecting multiple tables that are not associated, and not filtering data correctly
what you describe sounds strange. Because a slicer on a table can only affect that specific table and nothing else. Only slicers on pivot tables can be connected to several other pivot tables, as long as they are built from the same source table.
Are your tables on the same worksheet or on different worksheets? Please apologize if it is just a stupid assumption on my side, but if they are all on the same worksheet side by side, a filter on one table will effect automatically other tables, if the are sitting on the same rows (a filtered row will be invisible completely, and not only on the table where the filter gets applied)
what you describe sounds strange. Because a slicer on a table can only affect that specific table and nothing else. Only slicers on pivot tables can be connected to several other pivot tables, as long as they are built from the same source table.
Are your tables on the same worksheet or on different worksheets? Please apologize if it is just a stupid assumption on my side, but if they are all on the same worksheet side by side, a filter on one table will effect automatically other tables, if the are sitting on the same rows (a filtered row will be invisible completely, and not only on the table where the filter gets applied)
