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.

Radial charts from line charts

Radial charts from line charts - Power BI Tutorial

From the course: Power BI Weekly

Start my 1-month free trial Buy for my team

Radial charts from line charts

“

- [Instructor] Monthly temperatures typically follow a cyclical and predictable cycle within the 12 months of the calendar year. Hotter months occur during the summer and cooler weather occurs in the winter. There's a custom radial chart available for Power BI where we can also create it using the standard line chart visual combined with some DAX tricks and conditional logic. Line charts read from left to right. This means we can't have a point later in the sequence to the left of the current point. This makes it impossible to do a rotation around a circle with a single line, because the results will be undefined at some point. Instead, we need to segment the lines into a top line and a bottom line that will cross over in September and March to look like they're a single contiguous line. It's important to note that for a line chart like this to work, we need to put a dimension field like time or a value like we'll use…

Contents