From the course: Power BI Weekly

Unlock this course with a free trial

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

Displaying daylight times in an area chart

Displaying daylight times in an area chart - Power BI Tutorial

From the course: Power BI Weekly

Start my 1-month free trial Buy for my team

Displaying daylight times in an area chart

“

- [Instructor] Let's say that we're looking at the duration of a single day. Within each day, we have sunrise and sunset times that bookend the daylight hours. If we put all 365, or 366 days in a leap year, in a calendar year together, this creates a visual to display the daylight hours across the entire year. In Power BI Desktop, I already set up a data model for the sunrise and sunset times for multiple large metro areas around the US. We can select a location in the slicer to see how they change. Now let's visualize sunrise and sunset times for a selected location. We can't put times as values on our Y-axis when we create a visual either, but we can put values like those converted into an approximation for the 24-hour clock. Let's first add an area chart to our page. Order matters for the fields that appear in this visual. To make sure that the areas associated with each series display properly, we want to put…

Contents