Forum Discussion

Sanskruti's avatar
Sanskruti
Helper II
3 years ago

When using between slicer data doesn't show.

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. 

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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's avatar
      Sanskruti
      Helper II
      3 years ago

      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.