Area Chart in Power BI

Power BI Area Chart is the same as Line Chart. The area between axis and line is filled with colors to indicate volume.

Refer – Line chart in Power BI

Let’s get started-

Download Sample dataset- Global_superstore_2016.xls

Following these steps in order to create an Area chart-

Step-1: Import dataset from Global superstore file.

Step-2: Add Area chart into Power BI report canvas and drag below columns-

Axis: Month, Values: Sales & Profit

Area-chart-in-Power-BI

Step-3: Area chart with secondary values-

Drag Profit column in secondary values, and go to format section & enable Secondary Y-axis.

Area-chart-secondary-y-axis

Formatting Area chart-

You can set the font size, font family, Title name, X axis, Y axis & Data labels colors for chart visual.

Click any where on chart > Go to Format Section & set below properties-

General: Allows you to set X axis, Y axis, width & height of chart.

X-Axis: Set the font size, font family, color, display units, title & grid lines for x-axis.

Y-Axis: Set the font size, font family, color, display units, line style, title & grid lines for y-axis.

Secondary Y-axis: Set the font size, font family, color, display units & title for secondary y-axis.

Zoom Slider: Enables zoom feature on chart, using this you can easily saw the small values on chart.




Data colors: Using this section you can change the colors used for each series in the chart & customize the all line color individually.

Data labels: Its enable values on Line chart.

Shapes: You can enable markers on Line &  customize the marker shapes for all lines individually.

Title: Specified the Title name for chart.

Area-chart-after-formatting

Refer other Power BI topics: Power BI Visuals

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.