Home » Power BI Visuals » Area Chart in Power BI

Area Chart in Power BI

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

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 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.

Leave a Reply