Filter's not filtering the data set for periods in slicer

[Anonymous]

Hi Experts

i am trying to filter my data so the slicer shows the data for the following periods.

last 7 days

last 14 days

last 30 days and so on, but i am unable to make the sclier function for all the periods. File attached not sure what i have done wrong.

See sample file: https://www.dropbox.com/s/djcso9ibc38syw8/Date_LastNDaysFilter.pbix?dl=0

[v-diye-msft · Accepted solution]

Hi @Anonymous 

I just checked your data and found there's no sales amount in last 30/60/90 days, the valuable dates are from 2015/12/28-2017/1/28, 

that's why it showing blank. 

Also, I'd like to suggest you use the slicer by relative dates, that would be easier.

[amitchandak]

Refer, if this can help

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...