Common Slicer Filter two Related tables

Michele_1979 · #1 04-29-2024, 12:30 PM

Dear all,

I don't know if this is possible, but I would like to ask anyway.

I have two tables, with one two column with the same values in. I used these columns to establish the relation between the two tables.

I have then other columns, with the same name between the two tables, with some values in common and some others not in common, I would like to filter with slicers.

Is it possible to have slicers filtering in the same time both tables?

NOTE: I made the relation between the tables using data model.

Many thanks in advance.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Matching 2 tables by one common dataset	rippermaster	Excel Programming	1	06-11-2021 02:19 AM
Create a master slicer	kyingh	Excel	4	03-02-2019 11:24 PM
slicer in pivot	YH1978	Excel	0	11-19-2018 08:53 PM
Filter Mail Merge based on a list of filter criteria	AusSteelMan	Mail Merge	2	05-09-2016 03:35 PM
Need help with sorting a column by most common to least common	mikenmike0001	Excel	5	12-06-2011 05:17 PM