Incorrect dates displaying in desktop, but web is fine when published

I've just tried other date formats without asterisks in front, it's the same incorrect date coming up :(

I don't have the solution but I will continue to mull over the issue. At least we know what the problem is.

It also affected the online version. Not sure why the OP didn't have the same issue on his/her online version.

I 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.

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

I have the same issue. Any update? 

Thanks,

Indhu