Daylight Saving Time with weird behavior

[EduardoAASanti]

Dear all,

I am having an weird behavior with Daylight Saving Time (Brazilian Time). I have a "date" column in my DB located in Azure. When I load the data in Dashbord inside my PowerBI Desktop, the behavior is correct:

13/10/2017 00:00:00

14/10/2017 00:00:00

15/10/2017 01:00:00 (+1 because of Daylight Saving Time in Brazil)

16/10/2017 00:00:00

The problem is when I open the Dashboard in Web (app.powerbi.com). The result for the same is:

13/10/2017 12:00:00 AM
14/10/2017 12:00:00 AM
14/10/2017 11:00:00 PM (-1 because of Daylight Saving time in Brazil)
16/10/2017 12:00:00 AM

The consequence is, when I group by date, it repeats "14/10/2017" in the chart. Any sugestion in how to hangle it?

Thank you in advance,

Eduardo Santi

[v-sihou-msft · Accepted solution]

@EduardoAASanti

You can use DateTime.AddZone() function and DateTimeZone functions in Power Query to solve daylight saving and time zones issue. For more details, please refer to articles below:

Daylight Saving Time And Time Zones In M

Solving DAX Time Zone Issue in Power BI

Regards,

[kionis]

I have put in a feature request for PowerBI to natively support timezone and DST conversion. Please upvote if you'd like to see this happen: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/33732571-time-zone-conversion-acc...