Charts messed up when using UTC during local Daylight Saving change.

[GalaxyNetworks]

It may just be me. I actually hope it's just me being stupid. But does the charts really use local time to offset data?

I Denmark we changed to CEST at 3/25/2018 02:00 AM CET (or rather 3/25/2018 03:00 AM CEST)
This not only left a one hour hole in my data as my PowerBI timestamp column wasn't set to DateTimeZone. I guess it used my local time zone? Even though the values are in TZ format. That's Zulu time... Utc... +00:00!

After changing the column type the data hole was gone. In table view you can also clearly see the +00:00 offset now and the times looks correct.

Now lets plot the data in a chart: PowerBI - Image X-axis is timestamp and Y-axis is a test value.

The value for 12:00 +00:00 from the dataset is correctly shown on the chart with x = 12:00 AM.
The value for 01:00 +00:00 from the dataset is however also shon on the chart with x = 12:00 AM.
This of course looks odd when a power accumulation line suddenly goes one hour back in time... This is easily fixed by changing my system time to UTC, but that can't really be expected, right?

Am I missing some obvious options, or is this a bug in PowerBI?

/Peter

[v-yuezhe-msft]

@GalaxyNetworks,

Where do you change to CEST at 3/25/2018 02:00 AM CET ? Could you please post a screenshot about your local time zone setting and region setting?

From the above image, I note that custom values of 12:00 AM in the chart is not equal to custom value of 12:00 +00:00 +  custom value of 01:00 +00:00. Could you please post the original timestamp values without any data type formats in your table?

Regards,
Lydia

[GalaxyNetworks]

Hi, that image shows a test example of data entered directly into PowerBI. The timestamp entered is in TZ format. Like, 2018/03/29T23:45:00Z and 2018/03/30T01:00:00Z

After selecting date/time/zone as the datatype, my timestamps are now shown correctly in preview tables and when added to the report as a table view. So the data list shown in the picture is fine.

The problem is when I plot my values with the timestamp on the x-axis. If I plot y: 45, x: 12:45 AM, it correctly shows 45 at 12:45 AM. If I then plot 60 at 1AM it moves one hour back and plots it at 12AM.

My system timezone is set to Denmark/Copenhagen. +1 CET (+2 since we entered summer time - CEST)
If I change my system time to UTC the graph is shown correctly. That's why I'm wondering if the graph are using local time instead of just plotting the timestamps in its original format.

I will post some extra examples later...

/Peter