When using between slicer data doesn't show.

[Sanskruti]

Hello,

I have created a table which shows year month, order quantity and previous year order quantity.

And i have added a date slicer.
But when i change the date with the help of slicer i cant see the previous years data.

And when i use the dropdown slicer it shows me the previous year.

Why i'm facing this problem. 
And how can i show previous year when i'm using between slicer. (My client want between slicer).

Thank you. 

[amitchandak]

@Sanskruti , Make sure you have a date table and slicer, visual and measure using date table columns

Try measure like

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))

[Sanskruti]

Thank you for replying,
But i'm using same expression.

"PY OQ = CALCULATE(SUM(Aw_TotalSales[OrderQuantity]),dateadd('AW_Calendar'[Date].[Date],-1,Year))"

But still when i use slicer and select 2017 i cant see 2016 data.