Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a page with two line charts where the x-axis is a date & timestamp. At all times, I want the x-axis of chart 2 to be identical to that of chart 1. To do so, for both chart, I set a conditional format on the x-axis where the min & max are respectively the earliest & latest datetime column value used in the x-axis from chart 1.
The issue, the x-axis appears to be shifted by 5 hours. So if the min & max timestamp are respectively "1/15/2023 12:00:00 AM" & "1/15/2023 11:59:59 PM", the x-axis range is from "1/15/2023 5:00:00 AM" & "1/15/2023 4:59:59 AM". For reference, the below screenshot showcases the issue where the left & right date values show the earliest & latest values of the datetime column used to set the x-axis range.
I'm in the EST time zone & suspected it has something to with EST vs UTC settings, but found no settings in Power BI that should affect the timezone. The datetime column used also doesn't specify the timezone.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |