Home » Power BI Visual » Line charts in Power BI

Line charts in Power BI

Line charts in Power BI Example

Power BI Line charts is used to display change or trends over a period of time. A combination of two or more than two lines can be used to compare trends over time.

Implement Small multiples feature- Small multiples chart

Let’s get started-

Download the sample Dataset from below link-

Global_superstore_2016.xls



Following these steps in order to create a Line charts-

Step-1: Import Orders dataset from Global superstore file.

Step-2: Add Line charts into Power BI canvas and drag below columns-

Axis: Drag Year column

Values: Sales & Profit

Line chart in Power BI

Line chart in Power BI

Formatting Line charts

You can set the font size, font family, color for charts. Now click any where on chart then go to Format Section & set below properties-




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

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

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.

Data labels: Its enable values on Line chart.

Title: Specified the Title name for Line chart.

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

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

Line charts formatting

Line charts formatting



Line charts with Secondary Y axis-

Secondary Y-axis is used to display small values on line chart, Go to format section > Enable secondary Y-axis.

Line charts secondary y axis

Line charts secondary y axis

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