X-Axis Min/Max Timezone Bug

[lokar]

Since around monday 10/24/2022, when using a (fixed or FX) datetime value as MIN or MAX of a Graph axis, the value is "shifted" of 1 or 2 hours back (depending on the fact that the datetime selected is in the CET [+1] or CEST [+2] timezone).

It looks as if the datetime was converted from CET/CEST to UTC (subtracting 1/2 hours) and then the new "face value" of the UCT datetime was used as a MIN/MAX value for the x-axis.

The bug appears on the Desktop Client (Version: 2.110.805.0 64-bit (October 2022)) AND on the Power BI Service (patched yesterday 10/26/2022 with the latest version), even on reports that were published on February 2022 and were NEVER refreshed since then: those were correctly rendered at the time, and are now "shifted".

Thanks!

[v-yetao1-msft]

Hi @lokar 

I tried to restore the scene you described but failed. Can you provide your pbix file for our reference?

Best Regards,
Community Support Team _ Ailsa Tao

[lokar]

Hi @v-yetao1-msft,

Here's the PBIX, thanks!

https://www.dropbox.com/s/tixxin0ddujphw4/Test%20Case%20Date%20Time.pbix?dl=0

Best Regards,

Diego

[lokar]

Hi @Ailsa-msft,

could you reproduce the bug?

Regards,

Diego