In this article we will show you, How to Create a Stacked 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 a Stacked Area Chart in Power BI
In order to create a Stacked 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 the State Province Name to the Axis section.
Click on the Stacked Area Chart under the Visualization section. This will automatically convert the Column Chart into a Stacked Area Chart. From the below screenshot, you can see the Stacked Area Chart that shows the Sales Amount by State Province Name.
Let me add the Total Product Cost to Values as well. By this, you can compare the Sales Vs Product Cost by State province name.
Create a Stacked Area Chart in Power BI – Approach 2
First, click on the Stacked Area Chart under the Visualization section. This will automatically create a Stacked Area Chart with dummy data as shown in below screenshot.
In order to add data to Stacked Area Chart, we have to add required fields:
- Axis: Please specify the Column Name that represent the Stacked Area.
- Legend: Column that divides the values further
- Values: Any Numeric value(s) such as sales amount, Order Quantity, Total Sales etc.
Let me drag the Sales Amount and Total Product Cost 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.
From the above screenshot, you can see that the Stacked area chart is sorted by Sales Amount in descending order. So, let me sort the data by State Province Name. To do this, click on the … (3 dots) on top right corner, and select the Sort By State Province Name option as we shown below.
Let me do some quick formatting to this Stacked Area Chart
NOTE: Formatting options for both Area Chart and Stacked Area Chart are same. So, I suggest you to refer Format Area Chart article to understand the steps involved in formatting this Stacked Area Chart.
Let me add Product Color to the Legend section to show multiple dimensions.
Thank You for Visiting Our Blog