Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn 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
User | Count |
---|---|
96 | |
86 | |
78 | |
72 | |
67 |
User | Count |
---|---|
110 | |
104 | |
84 | |
65 | |
63 |