From the course: Power BI Weekly

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Configuring dynamic constant lines

Configuring dynamic constant lines - Power BI Tutorial

From the course: Power BI Weekly

Start my 1-month free trial Buy for my team

Configuring dynamic constant lines

“

- [Instructor] Reference lines are very helpful tools to call out or annotate thresholds within data trends directly on existing visuals. To set up dynamic constant lines on either the x or y-axes of an existing visual, we first need to set up a DAX measure that returns a constant result to use in it. We'll then add this measure as a constant line to the selected visual. In Power BI Desktop, I already created a line chart visual for the electricity demand in the Texas grid during the summer months of 2021. Constant lines work with several different visual types. But for this example, let's see how this works on a line chart. I also added a table visual next to it that contains the same data points which we'll use to check out the DAX calculations as we create them. Let's first create a calculation for the average electricity demand using the calculate and average functions on the demand field. We can see this average calculation returns the same results as the demand field that we…

Contents