Forum Discussion

jdobkows's avatar
jdobkows
New Member
9 years ago
Solved

One slicer for two tables

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 ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    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

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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