Home » Power BI Visual » Area Chart in Power BI

Area Chart in Power BI

Area chart visual 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: Line chart visual

Let’s get started-

Download the sample Dataset from below link-

Global_superstore_2016.xls

Following these steps in order to create an Area chart-

Step-1: Import Orders 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

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

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

Area chart after formatting

Refer more Power BI visuals- Power BI Visuals

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome.



Leave a Reply