Filter a single column from multiple slicers in Direct Query

 Hello experts,

I have a snapshot table which has snapshot date column. I need to show data for 2 snapshots based on date selection from the slicers.

To do this I have created 2 aliases of Date Dim table and joined with Snapshot table with below join:

SnapshotTable.snapshot_date=DateDim1.date

SnapshotTable.snapshot_date=DateDim2.date

I have added a slicer from DateDim1 to show one date, another slicer from DateDim2 to show another date.

Suppose if I choose 7/29/2021 from DateDim1 slicer and 8/3/2021 from DateDim2, the Snapshot table should show data for 7/29/2021 and 8/3/2021

When I choose any date from DateDim1 slicer, snapshot table shows me data for that snapshot date. But when I choose any date from DateDim2 slicer, it shows no data. My requirement is like below:

select * from SnapshotTable where snapshot_date in (7/29/2021,8/3/2021).

How to achieve this?

Regards,

Anilesh