One slicer for two tables

[jdobkows]

Hi,

I have two tables and I want to create one slider for time filter. It works when I create two relations between:

- Table_Sale and Table_Time on "Start date"

- Table_Purchase and Table_Time  on "Start date"

so when user filter data by "Start date" using slicer (Table_Time.Date) report works correctly, but when user want to filter by "End date" it doesn't work. System doesn't allow to create second relations between Table_Sale and Table_Time on "End date". 

Does anyone have an idea how to add passibility to create global filters on two dates (start and end date)?

[v-yulgu-msft · Accepted solution]

Hi @jdobkows,

We can create a second relation between Table_Sale and Table_Time on [End date] even there existing a relationship based on [Start date]. However, when we add Time_Table[Date] into a slicer, the filter works based on only one relationship. That is to say, we cannot neither use a signle slicer to filter start date and end date together nor dynamically filter start date and end date. For your requirement, the best choice is to create another date table, and create relationship between this new table and Table_Sale and Table_Purchase on [End date]. Then, use a second slicer to filter end date.

Best regards,
Yuliana Gu