Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

X axis timestamp shifted by a few hours

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. Screen Shot 2023-02-06 at 12.56.47 PM.png

 

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. 

0 REPLIES 0

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.