01 slicer to 02 different tables (table01 and table02)

[jr3151006]

Hi,

how can I have one slicer which when selected, it apply that date filter to table/pie chart/cards and etc related with 'Table01' and 'Table02'?

Just for example (even seams stupid), let's say that I have these tables:

TABLE01

#######

DATE_OF_BIRTH = Date

CAT_NAME = Text

SPECIE = Text

TABLE02

#######

DATE_OF_BIRTH = Date

DOG_NAME = Text

BREED = Text

I would like to set the slicer 'year' as '2022' and then, on the left side the table which shows CATS, shows "Cat01 | 25/05/2022" and at the right side the table shows "Dog02 | 14/07/2022".

[jr3151006]

Hi @tamerj1 ,

I used a query to create a new table with dates, after that I created a relationship between date fields on the tables. After that, the 'slicer' selection is beeing applied to entire page or 'slicer synced pages'.
Tks a lot!!

[tamerj1 · Accepted solution]

Hi @jr3151006 
A common date table should do the job. Get a date table and connect it with both tables via date column.