From the course: Power BI Weekly

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Add local midnight markers

Add local midnight markers - Power BI Tutorial

From the course: Power BI Weekly

Start my 1-month free trial Buy for my team

Add local midnight markers

“

- [Instructor] In an existing Power BI model, we have data representing the solar power generation for the Sunny Southwest Region of the United States. We can see how solar power generation peaks in the middle of the day and goes to zero at night when there's no sun. I chose this narrower date range because daylight savings occurred in this time zone on Sunday, March 12th, and I want to make sure the midnight markers I add properly account for this time change. We're using UTC datetimes on the x-axis to make sure we account for daylight savings in our measurements, but the local Mountain Time is also in the tool tips as well. We'll first create a DAX measure to determine the first date which the line chart starts. We can use the local date, but let's use the UTC date instead because it moves forward consistently through time without having to adjust for daylight savings. We'll find the first UTC date over all the…

Contents