Forum Discussion

soundguy2's avatar
soundguy2
Helper I
6 years ago

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...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi soundguy2 ,

 

It doesnt make sense,as you have modified the datetime column,there shouldnt be any time difference between ...

Did you use the new date/time column in the date field?

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
soundguy2's avatar
soundguy2
Helper I
6 years ago

Hi 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

  • nsmither's avatar
    nsmither
    Frequent Visitor
    3 years ago

    I have this issue as well, were you ever able to come up with a solution to this?

    • soundguy2's avatar
      soundguy2
      Helper I
      3 years ago

      Nope.  I've just accepted that we're not going to view today's sales after 5pm pacific time.  Sadly, it's been years since the original post on this.

       

      Regards,

      Brian