Slicer (Relative) shows date 1 day in the future

[carlomendoza]

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

[Anonymous · Accepted solution]

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