Power bi area chart (Everything you need to know)

In this Power Bi tutorial, let us understand how to use Power BI area chart, and the below points:

  • How to create a Power bi area chart
  • Power bi area chart transparency
  • Power bi area chart conditional formatting
  • Power bi area chart secondary axis
  • Power bi area chart secondary values
  • Power bi area chart color
  • Power bi area chart sort order
  • Power bi area chart trend line
  • Power bi area chart percentage
  • Power bi area chart drill down

What is Power Bi area chart?

The Power Bi area chart is also known as layered area chart and it is based on the line chart.

The area chart in power bi is used to show the magnitude of change over time, and it can be used to draw attention to the total value across a trend.

There are two types of area chart present in the Power Bi:

  • Area chart
  • Stacked area chart

Read: Power BI Clustered Column Chart

How to create a Power bi area chart?

Here we will see how to create Power bi area chart and power bi stacked area chart in Power bi desktop by using sample data.

You can download the sample data from here. Read an article on How to create Power BI report from SharePoint list + Excel

  • Open your Power bi desktop
  • Select the Get Data from the ribbon -> Excel Sheet.
  • Load the data to the Power bi desktop.
  • Now navigate to the report in Power bi desktop
  • From the visualization pane Select Area chart
  • Then drag-drop order date(month) and profit from the field pane to Axis and value respectively.
Power bi area chart
Power bi area chart
  • In the below screen-shot, you can see the basic area chart in power bi based on profit and sales by month.
Power bi basic area chart
Power bi basic area chart
  • From the visualization select the Stacked area chart in the Power bi.
Power bi stacked area chart
Power bi stacked area chart
  • Now you can see the Stacked area chart in the below screen-shot based on profit and sales by month.
power bi stacked area chart
power bi stacked area chart

Read: 5 Simple and Powerful Power BI dashboard examples

Power bi area chart transparency

Here we will see how to create Power bi area chart transparency using the above sample data.

  • In the Power bi report, select the area chart from the visualization.
  • Then drag-drop order date(month) and profit from the field pane to Axis and value respectively.
field formatting in power bi
field formatting in power bi
  • In the format section, go to the background color and select a background color.
  • Then you can set the transparency of background color from 1 to 100 in the power bi area chart. Here we set the transparency is 12%.
transparent background power bi
transparent background power bi
  • In the below screen-shot, you can see the Power bi area chart transparency(12%).
power bi area chart transparency
power bi area chart transparency

Read: Microsoft Power bi report vs dashboard

Power bi area chart conditional formatting

Here we will see the power bi area chart conditional formatting by using the above sample data

First we will create visuals using Stacked column chart and then we will convert it to area chart.

  • In the Power bi report, select the stacked column chart visualization
  • Then drag-drop product category and sales from the field pane to Axis and value respectively.
field formatting in power bi
field formatting in power bi
  • In the Format section, Turn on the Data label. Then select the Data colors and click on the conditional formatting(fx)
conditional formatting in power bi
conditional formatting in power bi
  • In the Default color dialog box, under format by select color scale. Then under based on field, select Sales, and under summarization select Average.
  • Under minimum, you can custom the value by selecting custom or select the Lowest value and set a color.
  • In the same way, you can set the maximum value and set the color.
  • If you want to add the middle value and color, first check the Diverging, then you can set the Middle value and color. Click on Ok.
default data color in power bi
default data color in power bi

Now we will convert Stacked column chart to area chart.

  • From the visualization select the power bi Area chart
Power bi area chart
Power bi area chart
  • You can see the Power bi area chart with conditional formatting in the below screen-shot.
power bi area chart conditional formatting
power bi area chart conditional formatting

Read: How to combine multiple files from SharePoint folder in Power BI

Power bi area chart secondary axis

Here we will see How to create power bi area chart secondary axis using the above sample data.

  • In the power bi report, select the area chart from the visualization.
  • Then drag-drop order date(month) sales and profit from the field pane to Axis,value and secondary value respectively.
field formatting in power bi
field formatting in power bi
  • Now in the Format section, under visualization, you can turn on the secondary axis after adding the secondary values.
  • In the secondary axis section, you can change the start value, end value, color, text size, font family, display units, and title of the secondary axis of the power bi area chart.
secondary axis in power bi
secondary axis in power bi
  • In the below screen-shot you can see the Power bi area chart secondary axis.
 Power bi area chart secondary axis
Power bi area chart secondary axis

Read: How to Embed Power BI Report in SharePoint Online

Power bi area chart secondary values

Here we will see how to create Power bi area chart secondary values by using the above sample data.

  • In the power bi report, select the area chart from the visualization.
  • Then drag-drop order date(month) sales and profit from the field pane to Axis, value, and secondary value respectively. Make sure you have not added an argument to the legend while adding secondary values because power bi visuals don’t support both the multiple values and legend.
field formatting in power bi
field formatting in power bi

Now you can see the secondary values in the y-axis of the Power bi area chart.

Power bi area chart secondary values
Power bi area chart secondary values

Power bi area chart color

Here we will see How to change Power bi area chart color using the above sample data.

  • Select area chart from the visualization in the power bi report.
  • Then drag-drop order date(month) and profit from the field pane to Axis and value respectively.
field formatting in power bi
field formatting in power bi
  • In the format section, go to data colors-> under field(Profit), select a color you want.
data colors in power bi
data colors in power bi
  • In the below screen-shot, you can see the Power bi area chart color.
 Power bi area chart color
Power bi area chart color

Read: Power BI Pie Chart – Complete Tutorial

Power bi area chart sort order

Here we will see how to create Power bi area chart order using the above sample data.

  • In the power bi report, select the area chart from the visualization.
  • Then drag-drop order date(month) and sales from the field pane to Axis and value respectively.
field formatting in power bi
field formatting in power bi
  • In the canvas of power bi, Click on the More icon on the top of the visuals.
  • Here you can sort the order of visuals in 3 ways to sort visuals i.e sort ascending, sort descending, and sort by. The sort by features in power bi is used to sort the visuals according to field
  • If I have selected the sort ascending and then select Sort by->Sales, then the sales data in visuals show from lowest to highest.
  • Accordingly, you can sort the sales value as descending.
Sort by in power bi
Sort by in power bi
  • In the below Screen-shot, you can see the Power bi area chart sort order (descending).
Power bi area chart sort order
Power bi area chart sort order

Power bi area chart trend line

Here we will see the How to add power bi area chart trend line using the above sample data.

  • In the Power bi blank report, select the area chart from the visualization.
  • Then drag-drop order date(year and month) and profit from the field pane to Axis and value respectively.
field formatting in power bi
field formatting in power bi
  • Now, if you want to add the power bi trend line from the analytics, it will not appear in the default setting.
no trend line power bi
no trend line power bi
  • To get trend line, go to the format section under visualization pane, Select X-axis->Type-> continuous.
continuous x axis power bi
continuous x axis power bi
  • Now go to the Analytics section under visualization, you can see the trend line, Click on it.
  • Click on Add icon. Then give a name to the trend line. And also you can change the color and style of the trend line and you can set the transparency of the trend line.
trend line in power bi
trend line in power bi

In the below screen-short, you can see the Power bi area chart trend line.

Power bi area chart trend line
Power bi area chart trend line

Read: Power Bi line chart

Power bi area chart percentage

Here we will see how to create power bi area chart percentage using the above sample data.

  • In the Power bi blank report, select the area chart from the visualization.
  • Then drag-drop order date(month) and profit from the field pane to Axis and value respectively.
field formatting in power bi
field formatting in power bi
  • In the value section, click on the drop-down->Show value as->percentage of grand total.
percentage of grand total in power bi
percentage of grand total in power bi
  • In the below screen-shot, you can see Power bi area chart percentage.
Power bi area chart percentage
Power bi area chart percentage

Power bi area chart drill down

Here we will see how to set the Power bi area chart drill down using the above sample data.

  • In the power bi report, select the power bi area chart from the visualization
  • Then drag-drop order date(year and month) and profit from the field pane to Axis and value respectively.
field formatting in power bi
field formatting in power bi
  • In the canvas area, top of the visuals, select the fork icon then it will expand all down one level of hierarchy. Make sure that your visuals have a hierarchy, then only you can use the drill feature.
power bi drill down
power bi drill down
  • After drill down, it takes one level down in the hierarchy (Order date), it goes drill down from year-> month year. In the below screen-shot, you can see the Power bi area chart drill down by using the fork icon
power bi area chart drill down
power bi area chart drill down
  • If you want to see the only months in the visual after drill down, then select the double down arrow, on the top of the visual.
power bi drill down
power bi drill down
  • In the below screen-shot, you can see the Power bi area chart drill down by using the double arrow icon.
power bi area chart drill down
power bi area chart drill down

You may like the following Power BI tutorials:

In this power bi tutorial, we learned What is Power bi area chart. And also we discussed about

  • How to create a Power bi area chart
  • Power bi area chart transparency
  • Power bi area chart conditional formatting
  • Power bi area chart secondary axis
  • Power bi area chart secondary values
  • Power bi area chart color
  • Power bi area chart sort order
  • Power bi area chart trend line
  • Power bi area chart percentage
  • Power bi area chart drill down
>