Forum Discussion
Relative 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...
Not exactly a perfect fix, but a workaround that worked for me was to apply the filter to the dataset in Power Query. Basically just filtering out any data that isn't from today, then removing the filter entirely within the report.
Not my solution, here is the link to post where I initally saw it: https://community.fabric.microsoft.com/t5/Desktop/Relative-moving-Forward-one-day-after-8PM/td-p/1803497