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
Step-3: Area chart with secondary values-
Drag Profit column in secondary values, and go to format section & enable 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.
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.
Unable to find Data colors in Formatting. on PBI v 2022.12