Forum Discussion
Incorrect dates displaying in desktop, but web is fine when published
I have the exact same issue as well at one of our client, just noticed it yesterday. I am using the latest Power BI desktop Version: 2.57.5068.501 64-bit (April 2018)
The 'incorrect' date appears to always be a Sunday and in either week 39 or week 40 depending on the year (might have to do with some years have 52 and others have 53 weeks). See attached imaged (highlighted).
Helper IIIs there any chance the underlying data has a time component that is shifting particular records between days based on timezones?
No, the CalendarDate column is date only, no time whatsoever (or all is 00:00:00), unless.... that's when the Daylight Savings Time kicks in, which it is for some of the more recent years but not for for the old years.
So I brought in the time component, all 00:00:00, and voila, at the date where it's shown wrong, the clock has been winded back 1 hour (from 12:00 AM to 11:00PM) and hence why the date is shown as previous date. And I've used the datetimeoffset for the CalendarDate data type, with UTC timezone (+00:00). If I look at April, sure enough it winds the clock forward 1 hour.
- Ormesome
Does it make a difference whether the field is a Date/Time or a Date? I'm hoping that telling the Data Model that it's a Date will cause it to ignore any time shifting.
even with data type = Date, it is still shifting the hour.