Data not showing in table

[Anonymous]

Ok all day my data has been in my table but now doesn't seem to work.  I have a date filter to show just previos days data and it has worked all day.  I have the filter set to show just previous day.

Worked just fine and now that it is 8pm eastern time on 12/3/2019 it will not show data from 12/2/2019.  Now if I change the settings to show 2 previous days 12/2/2019 data shows back up.

Help why today is still 12/3/2019 and will be for another 4 hours so 12/2/2019 data should still be there.

[VasTg · Accepted solution]

@Anonymous 

I create a column with below data to test it and my assumption in previous post was wrong.

12/02/2019 00:00

12/02/2019 01:00

12/02/2019 02:00

12/02/2019 03:00

12/02/2019 04:00

12/02/2019 05:00

12/02/2019 06:00

12/02/2019 07:00

12/02/2019 08:00

12/02/2019 09:00

12/02/2019 10:00

12/02/2019 11:00

12/02/2019 12:00

12/02/2019 13:00

12/02/2019 14:00

12/02/2019 15:00

12/02/2019 16:00

12/02/2019 17:00

12/02/2019 18:00

12/02/2019 19:00

12/02/2019 20:00

12/02/2019 21:00

12/02/2019 22:00

12/03/2019 00:00

12/03/2019 01:00

Check out the limitation section in the link.

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

All the dates are based on UTC and UTC is 5 hours ahead of EST, so your cutoff would be 7PM

If this helps, mark it as a solution.

Kudos are nice too.

[VasTg]

@Anonymous 

Are the filtered column Datatime datatype? Maybe it is trying to filter 24 hours(even with relative 1 day) and you do not have any data in the past 24 hours?

Just a thought.