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