Forum Discussion

MAFE62's avatar
MAFE62
Frequent Visitor
6 years ago

Date value is changed when visualized from a dataset

Hi guys, I started to learn Power BI 2 months ago. I have been solving some problems looking for solutions in this community, however currently I have the following scenario and I haven't find a sol...
Need Help
danextian's avatar
danextian
Super User
6 years ago

If I am not mistaken  PBI service is using GMT +0. I would convert Baseline Finish and Actual Finish columns to a GMT + 0 timezone then convert it to your local timezone. You can add a custom colum in Power Query using 

DateTimeZone.SwitchZone ( Datetime.AddZone ( [datetimecolumn], 0 ), yourtimezone )

 

If your colums aren't datetime, you may convert it to that format first. After adding the custom columns, you can switch the data type back to date only.

MAFE62's avatar
MAFE62
Frequent Visitor
6 years ago

danextian,

 

The columns Baseline Finish and Actual Finish are datetime.

 

My question is: The conversion occurs even when the data comes from a field in a user table?

 

Thanks,

Mafe62

  • danextian's avatar
    danextian
    Super User
    6 years ago

    I'm thinking it could be because, in the backend, the database actually uses a different timezone. But once a report is exported, datetime fields are changed to the timezone of the user based on location or whatever was set by the user. I encountered this when working on Salesforce objects - time datetime info on the website and the report is different from that in the object.