cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
carlomendoza Frequent Visitor
Frequent Visitor

Slicer (Relative) shows date 1 day in the future

In Power BI Desktop, I have date data that only goes up to 2019-02-18, When I set the slicer to "Last 1 day" it filters from 2019-02-19 to 2019-02-19 showing no data. Why does it behave like that? Not sure if it makes sense.

 

"Last 1 day" to me would mean 2019-02-18 to 2019-02-19

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Slicer (Relative) shows date 1 day in the future

Hi @carlomendoza 

 

  Assuming your current day is 2019-02-19, then your last day is 2019-02-18 and your current day is 2019-02-19.

 

So for this case, when you select " Last 1 days" this should be 2019-02-19.

 

If you need from 2019-02-18 to 2019-02-19 then you need to select "Last 2 days".

 

Hope this is clear.

 

Thanks

Raj

 

1 REPLY 1
Highlighted
Super User
Super User

Re: Slicer (Relative) shows date 1 day in the future

Hi @carlomendoza 

 

  Assuming your current day is 2019-02-19, then your last day is 2019-02-18 and your current day is 2019-02-19.

 

So for this case, when you select " Last 1 days" this should be 2019-02-19.

 

If you need from 2019-02-18 to 2019-02-19 then you need to select "Last 2 days".

 

Hope this is clear.

 

Thanks

Raj