How To Add Average Line In Power Bi

by

How to Add Average Line in Power BI

Adding an average line to a visual in Power BI can provide valuable insights and context to your data. Here is how you can achieve this:

  1. Select the visual or chart where you want to add the average line. You can choose from various visuals like column chart, line chart, or scatter chart.
  2. Go to the “Visualizations” pane on the right-hand side.
  3. Click on the “Analytics” tab, which is represented by a graph icon.
  4. Scroll down and find the “Average Line” option. Enable it by toggling the switch to “On”.

Now, let’s take a look at some examples to further explain the process:

Example 1: Adding Average Line to a Column Chart

Suppose you have a column chart visual representing sales data for various product categories. To add an average line:

  1. Select the column chart visual.
  2. Go to the “Visualizations” pane on the right-hand side.
  3. Click on the “Analytics” tab.
  4. Toggle the switch for “Average Line” to “On”.

The average line will now appear on the chart, representing the average sales across all categories.

Example 2: Adding Average Line to a Line Chart

Let’s say you have a line chart visual showing the stock prices of a company over time. To add an average line:

  1. Select the line chart visual.
  2. Go to the “Visualizations” pane on the right-hand side.
  3. Click on the “Analytics” tab.
  4. Toggle the switch for “Average Line” to “On”.

The average line will now be displayed on the chart, indicating the average stock price over the given time period.

Leave a comment