Forum Discussion
Incorrect dates displaying in desktop, but web is fine when published
It also affected the online version. Not sure why the OP didn't have the same issue on his/her online version.
Helper III can't replicate the problem, but this thread (https://community.powerbi.com/t5/Desktop/Converting-Date-Time-to-Local-Time-considering-Daylight-savings/td-p/104389) indicates that there is a date/time/timezone datatype. Maybe this is being applied to your data somehow?
Would you try a calculated column and let me know how it goes?
__trueDate = DATEVALUE([date_with_dts])
I typically use this to strip the time component from fields.
The same issue is still showing up using the calculated column you suggested.
It may have to do with regional setting, just not sure where, as it's online version. I can understand desktop version may be impacted by region setting. One of my director in US doesn't have this issue, both desktop and online. I'm in Australia.
I'll try to put the timezone (which I think should solve it) information into the date calendar over the weekend to see what happened.
- mike_honey
Memorable Member
One of my clients bought this to my attention and I was quickly able to repo it. I'm sure it's a bug.
Please review my repo added to this Issue report and if you agree then vote it up and add your comments to confirm, and highlight it's importance to the Product Team.
https://community.powerbi.com/t5/Issues/Bug-October-1/idc-p/400669
indhuHelper III
I have the same issue. Any update?
Thanks,
Indhu
