cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shane86
Frequent Visitor

Desktop refreshing at 4:00 pm rather than 12:00 midnight

im assuming this has something to do with UTC but im still stumped. i have relitive date filters on my dashboard that filters to the current month. At the end of the month at 4:00pm it updates to the next month. this is frustrating when were often down to the wire to get orders out and want to see where revenue is hitting but the dashboard has already updated to the next month. im hoping it a simple fix and not something where i have to link all the dates to a new timezone or something. any help is greatly appreciated!

1 ACCEPTED SOLUTION
lbendlin
Super User III
Super User III

3 REPLIES 3
lbendlin
Super User III
Super User III

Shane86
Frequent Visitor

Thanks for the reply!

 

I was hoping it wouldnt come to that. so do i just create another column in the data and do a dax formula to the original date and add/subtract hours to get the desired time? Thats how i understand the "Method 1" in the link you sent at least

yes but that will only work if all your users are in the same timezone.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors