Several slicers with several tables

[hamtuv]

Hello! I have a problem where i want to have several slicers that affect my graphs

My data is the following, I have several tables that have some columns but they all have a Year column and a Management column. I then want a slicer for each of those columns that filter my graphs depending on which year and management I have selected.

The tables look something like this.

TABLE 1:

Management	Year	Amount
Management 1	2023	120
Management 2	2023	104
Management 3	2024	100

TABLE 2:

Management	Year	Amount
Management 1	2022	130
Management 2	2023	111
Management 3	2024	107

[PijushRoy · Accepted solution]

HI @hamtuv 

In Power Query, create two lookup tables for Year and Management.
Create a relationship with Table 1 and Table 2 
Use the lookup table in the slicer