Relative Date Filtering Issue

[Anonymous]

Hi support,

I created some data in power bi desktop, the date is from 21/09/2019 to 30/09/2019. I created a table and set the date filter to last 3 days, the table should show data on 30/09 & 29/09 & 28/09 since the max date is 30/09, why it shows a blank? I checked the date filter, why the date span is from 26/10 - 28/10 instead of 28/09 - 30/09?

[Anonymous]

Hi Support,

Any feedback on this issue?

Thanks,

Lei

[v-yuta-msft]

@Anonymous ,

You may misunderstand the meaning of "in the last", in the last 3 days means the last three days from today, not from the max date in your column. 

If you need to filter the last 3 days from the max date in column, you may use Top 3 latest date as below:

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Any feedback?

Thanks

[Anonymous]

Hi,

As you mentioned before,  the 'Last 3 days' means last 3 days from 'today', is the date slicer only  used for data that growing or refreshing every day, if the data stops growing, the reports or dashboards  with the relative date slicers  will be blank after some days? 

Sorry for so many questions.

Thanks,

Lei

[Anonymous]

Hi,

Also if I change the date to datetime(same date with different time) how can I set the TOP N slicer to filter last 3 days data?  I think Top 3 will not work  in this case.

Thanks,

Lei

[Anonymous]

Hi Jimmy,

Thanks for your explanation! I already applied a Top N filter in the table, and can't add another one in the same visual, if there is another solution to offset the starting point based on the maxmum date?

As for the relative date filter, the maximum date in my data source is 30/09/2019, why there are some dates that not exist in my table are showing when change the slicer style to 'Relative', do you think it's a bug?

Thanks

Lei