Forum Discussion
soundguy2
Helper I
Helper IRelative Date Filtering - date moving ahead too early
I'm attempting to use Relative Date Filters to display sales in the last 1 day (the current calendar date). It works fine for most of the day but at about 5pm PST the filter moves to the next calend...
soundguy2Helper I
Helper IHi Kelly,
There definitely is a time difference when using a date column that has been modified. Following your directions, I can adjust so that the daily sales is correct after 5PM, however I then see yesterday's sales before 5PM. The relative date filter always changes at 5PM so there is always some difference before and after that time.
The real kicker was this evening (April 30) when all April sales disappeared because that report was using the "is in this month" filter. Unless there's secret way to realign the relative date filter to the user's time, we'll have wait for the Power BI team at Microsoft to address this one. Thanks again.
Regards,
Brian
I have this issue as well, were you ever able to come up with a solution to this?