Area Chart in Power BI

Power BI Area Chart is same as Line Chart where the Area between the X-Axis and lines are filled with a color. In this article we will show you, How to Create an Area Chart in Power BI with example.

For this demonstration we are going to use the SQL Data Source that we created in our previous article. So, Please refer Connect Power BI to SQL Server article to understand the Data Source.

How to Create an Area Chart in Power

In order to create an Area Chart, first Drag and Drop the Sales Amount from Fields section to Canvas region. This will automatically create a Column Chart as we shown in below.

Next, let me add English Product Subcategory Name to Axis section.

Click on the Area Chart under the Visualization section. This will automatically convert the Column Chart into an Area Chart. From the below screenshot, you can see the Area Chart that shows the Sales by Product Subcategory.

Create an Area Chart in Power BI – Approach 2

First, click on the Area Chart under the Visualization section. This will automatically create an Area Chart with dummy data as shown in below screenshot.

In order to add data to Area Chart, we have to add required fields:

• Axis: Please specify the Column Name that represent the Area.
• Values: Any Numeric value such as sales amount, Total Sales etc.

Let me drag the Sales Amount from Fields section to Values field.

Next, let me add State Province Name to Axis section. You can do this by dragging State Province to Axis section, or simply check mark the State Province column.

Let me sort the data by State Province Name (By default, it is sorted by Sales Amount). To do this, click on the … (3 dots) on top right corner, and select the Sort By StateProvinceName option as we shown below.

Now you can see more meaningful area chart

Hover over any position will show you the Tool-tip of Sales Amount, and State Province Name

By adding Product Color to the Legend section will convert the Area chart into Stacked Area chart.

Let me remove the Color field from Legend section and add one more field i.e., Total Product Cost to Values section. This will compare the Area of Sales Amount against the Total Product Cost.

Hover over any position will show you the Tool-tip of Sales Amount, and Total Product Cost

Let me do some quick formatting to this Area Chart

NOTE: I suggest you to refer Format Area Chart article to understand the steps involved in formatting the Area.

Thank You for Visiting Our Blog