Skip to main content
Power BIPowerBI tutorials

Area chart in Power BI

Power BIPowerBI tutorials

Area chart in Power BI

The Power BI area chart is the same as the line chart, where the area between the X-axis and the lines is filled with a color. Let me show you how to create an area chart in Power BI with an example.

For this demonstration of the Power BI area chart, we will use the SQL data source that we created in our previous article.

See the article Connect Power BI to SQL Server to understand the data source in Power BI. And also see the article Line Chart.

How to create an area chart in Power BI

To create an area chart in Power BI, first drag and drop the Sales Amount section of the fields to the region of the canvas. Automatically create a column chart, as shown in the following screenshot.

area-chart-in-power-bi-1-5225538

Next, let me add the name of the English product subcategory to the Axis section.

area-chart-in-power-bi-2-1073537

Click on the area chart below the Display section. It will convert the column chart to an area chart. In the screenshot below, you can see the area chart showing the sales by product sub-category.

area-chart-in-power-bi-3-1988706

Create an area chart in Power BI focus 2

First, click on the area chart below the Display section. You will create an area chart with fictitious data, as shown in the following screenshot.

area-chart-in-power-bi-4-5806430

To add data to the Power BI area chart, we have to add the required fields:

  • Axis: Specify the name of the column that represents the area.
  • Values: Any numerical value such as sales amount, total sales, etc.
Maybe you are interested >>>  Scatter chart in Power BI

Let me drag the sales amount from the Fields section to the Values field.

area-chart-in-power-bi-5-1319898

Next, let me add the name of the state province to the Axis section. You can do this by dragging State Province to the Axis section, or just check the State Province column.

area-chart-in-power-bi-6-5493012

Let me sort the data by state province name (by default it's sorted by sales amount). To do this, click on the (3 dots) in the upper right corner and select the Sort by stateProvinceName option as we show below.

area-chart-in-power-bi-7-9741884

You can now see a more meaningful area chart

area-chart-in-power-bi-8-6536041

Hover over any position to display the Sales Amount and State Province Name tooltip

area-chart-in-power-bi-9-5063945

Adding Product Color to the Legend section will convert the Power BI Area chart to the Stacked Area chart.

area-chart-in-power-bi-10-7644214

Let me remove the Color field from the Legend section and add one more field i.e Total Product Cost to Values section. Compare the amount of the sales area with the total cost of the product.

area-chart-in-power-bi-11-1006587

Hover over any position to display the Sales Amount and Total Product Cost tooltip

area-chart-in-power-bi-12-5822343

Let me quick format this Power BI area chart

NOTE: I suggest you refer to the article Formatting the area chart to understand the steps required to format the area chart title, chart area, line color, etc.

area-chart-in-power-bi-13-5333454

The Power BI area chart is the same as the line chart, where the area between the X-axis and the lines is filled with a color. Let me show you how to create an area chart in Power BI with an example.

For this demonstration of the Power BI area chart, we will use the SQL data source that we created in our previous article.

See the article Connect Power BI to SQL Server to understand the data source in Power BI. And also see the article Line Chart.

How to create an area chart in Power BI

To create an area chart in Power BI, first drag and drop the Sales Amount section of the fields to the region of the canvas. Automatically create a column chart, as shown in the following screenshot.

area-chart-in-power-bi-1-5225538

Next, let me add the name of the English product subcategory to the Axis section.

area-chart-in-power-bi-2-1073537

Click on the area chart below the Display section. It will convert the column chart to an area chart. In the screenshot below, you can see the area chart showing the sales by product sub-category.

area-chart-in-power-bi-3-1988706

Create an area chart in Power BI focus 2

First, click on the area chart below the Display section. You will create an area chart with fictitious data, as shown in the following screenshot.

area-chart-in-power-bi-4-5806430

To add data to the Power BI area chart, we have to add the required fields:

  • Axis: Specify the name of the column that represents the area.
  • Values: Any numerical value such as sales amount, total sales, etc.
Maybe you are interested >>>  Pin report to Power BI dashboard

Let me drag the sales amount from the Fields section to the Values field.

area-chart-in-power-bi-5-1319898

Next, let me add the name of the state province to the Axis section. You can do this by dragging State Province to the Axis section, or just check the State Province column.

area-chart-in-power-bi-6-5493012

Let me sort the data by state province name (by default it's sorted by sales amount). To do this, click on the (3 dots) in the upper right corner and select the Sort by stateProvinceName option as we show below.

area-chart-in-power-bi-7-9741884

You can now see a more meaningful area chart

area-chart-in-power-bi-8-6536041

Hover over any position to display the Sales Amount and State Province Name tooltip

area-chart-in-power-bi-9-8276017

Adding Product Color to the Legend section will convert the Power BI Area chart to the Stacked Area chart.

area-chart-in-power-bi-10-4582333

Let me remove the Color field from the Legend section and add one more field i.e Total Product Cost to Values section. Compare the amount of the sales area with the total cost of the product.

area-chart-in-power-bi-11-3601126

Hover over any position to display the Sales Amount and Total Product Cost tooltip

area-chart-in-power-bi-12-2927274

Let me quick format this Power BI area chart

NOTE: I suggest you refer to the article Formatting the area chart to understand the steps required to format the area chart title, chart area, line color, etc.

area-chart-in-power-bi-13-5298785
error: Attention: Protected content.