Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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.
Refer, if this can help