Area Charts in Power BI

Click on the “Area chart” (the second one from the above red square box) in the “Visualizations” pane. This creates a chart box in the canvas. Resize after the drag as per the user’s requirement and set options for the x-axis, y-axis, secondary y -axis, legend and other fields as per your preference.

Example 1

Set the Visualization pane: We want to show volumes of data based on quartered time. The vertical axis shows average loan taken by both the genders with average remaining debt left out. Set the visual pane as shown below and notice the output achieved for a better understanding of the working of area chart. Keep hovering on different data points for more details and understanding.

Output: The light-blue colored area chart is shown for females and the dark-blue is for males. This is shown for the second quarter as an example of its working after the fields setting in the Visual pane.

Another Output: Let us analyze for the third quarter by changing the hover on the next data point.

Example 2

By following similar steps, let us analyze another example.

DataSet: In this example, we are taking another dataset namely “SaleData.xlsx“. An idea of the dataset can be taken from the following screenshot.

Follow the similar steps for getting data, navigating the excel sheet and loading in the Power BI desktop. Do the same procedure for drag and drop the area chart in the canvas and set the visual pane to see the area chart.

Changing the setting of visual pane and its fields. Let us take the months in the x-axis. We are showing the sum of sale amount based on different months for the years 2018 and 2019 (set in legends)

Output:

Video output: Keep hovering on various data points to see and analyze datasets in detail for both the year’s total sale amount for items sold.

Example 3

Considering the “DataSet.xls” in the example 1 of this article, we are showing the area chart in a different manner. The loans are being taken for different purposes like “Home”, “Education”, “Travel”, “Personal” and so on. Let us analyze average of loan and average of remaining debt for different purpose based on years (x-axis). In the visual pane, set the “Small multiples” field with “Purpose” so as to show the “Purpose” in different sections of the area chart.

Output: The light-blue area chart is for the average of loan and dark-blue area is for the average of remaining debt for the years shown in the bottom x-axis.

Video output:

Example 4

To get a different view of area chart, set the fields as given below by drag and drop from the data pane.

Output:

Change the visual pane setting of x-axis to the following and see the effect. The x-axis is changed to “Year” along with the “Date Month” option. The user can change the fields and see the affect as per the requirement.

Output:

In this article, we will learn to implement basic area charts using Power BI. This discusses some important concepts used to create the very common area charts so as to make large business intelligence decisions made out of analyzing data trends. We will be discussing the following topics and their implementation in the Power BI desktop.