Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Super User

3 REPLIES 3
lbendlin
Super User
Super User

Nopes, not a simple fix. Time zones are hard.

 

https://radacad.com/solving-dax-time-zone-issue-in-power-bi

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.