How to Create Line Chart in Power BI?

Do you know how to create line chart in Power BI? Don’t worry!

In this Power BI tutorial, We will discuss what a line chart in Power BI is, how to create a line chart in Power BI, and how to plot multiple lines on a Line chart in Power BI, Power BI Line chart multiple lines with Legend.

Also, we will discuss how to add a secondary axis in the Power BI Line chart and how to create small multiples in the Power BI Line chart.

Additionally, I will explain Power BI line chart formatting, like:

  • How to add Data Labels to a Power BI Line chart
  • What is a Zoom Slider in Power BI Line chart
  • Power BI Line Chart color lines
  • Use Plot area background in the Power BI Line chart

Line Chart in Power BI

  • Power BI line chart shows a line that connects data points over time. Imagine tracking monthly sales. The Line Chart helps you easily see trends, highs, and lows.
  • A Power BI line chart may include one or multiple lines.
  • Power BI Line charts have an X-axis and a Y-axis.
How to Create Line Chart in Power BI

How to Create Line Chart in Power BI

Let’s follow step-by-step instructions on creating a line chart in Power BI.

We have a SharePoint list (Financial Sample) having with these many columns below with different data types:

ColumnsData Types
Month NameSingle line of text
ProductSingle line of text
SalesCurrency
ProfitCurrency
Units SoldNumber
CounrySingle line of text
Month NumberNumber
SegmentSingle line of text
line chart in Power BI

1. Open Power BI Desktop and load the data. Then, in the Data Panel, you can see the data set.

How to Make Line Chart in Power BI

2. Under the Visualizations panel, click the Line chart.

Basic Line Charts in Power BI

3. Then drag the Month Name into the X-axis and Sales into the Y-axis.

Create line charts in Power BI

This way, you can create a line chart in Power BI Desktop.

How to Plot Multiple Lines on a Line Chart in Power BI

In the above example, you see the line chart has one line in the chart. I will show you how to add multiple lines on a line chart in Power BI.

I hope you create the above example. In the same example, add Profit into the Y-axis.

power bi line chart multiple lines

In this process, you can add multiple lines on a line chart in Power BI.

Power BI Line Chart Multiple Lines with Legend

Now, I will tell you how to add multiple lines in the Power BI line chart with a legend field.

1. Open Power BI Desktop and load data. Then, in the Data Panel, you can see the data set.

How to Make Line Chart in Power BI

2. Under the Visualizations panel, click the Line chart. Then, drag Month Name into the X-axis, Sales into the Y-axis, and Product into the Legend field.

Multiple values in line chart with legend in Power BI

This way, you can add multiple lines in the Power BI Line Chart.

How to Add Secondary Axis in Power BI Line Chart

In simple steps, I will explain why and how to add a secondary axis in the Power BI Line Chart.

The secondary axis in a Power BI Line Chart has two Y-axes on the same chart. It’s useful when comparing two sets of data with different scales. Looks like the line chart below.

Dual Y Axis Line Chart Visual for Power BI

Let us see how it creates:

1. Open Power BI Desktop and lode data. Then, in the Data Panel, you can see the data set.

Dual Axis Line Chart in Power BI

2. Under the Visualizations panel, click the Line chart. Then, drag Month Name into the X-axis, Sales into the Y-axis, and Units Sold into the Secondary y-axis field.

Dual Y axis in Power BI Line chart

This way, we can add a secondary axis to the Power BI line chart.

Create small multiples in the Power BI Line Chart

We will show you how to create small multiples in the Power BI Line Chart.

Small multiples in a Power BI line chart are like having several mini-line charts, each focusing on a specific category or group. Instead of one big chart, we get smaller ones for individual items. Looks like the line chart below.

Small Multiples Chart In Power BI line chart

Let us see how it creates:

1. Open Power BI Desktop and lode data. Then, in the Data Panel, you can see the data set.

Interact with small multiples in Power BI line chart

2. Under the Visualizations panel, click the Line chart. Then, drag Month Name into the X-axis, Sales into the Y-axis, and Product into the Small multiples field.

How to Create small multiples in the Power BI Line Chart

During this process, we can create small multiples in the Power BI line chart.

Power BI Line Chart Formatting

Now, we will discuss some formatting in the power BI line chart. I hope you have already created a line chart.

How to add Data Labels to a Power BI Line Chart

Data labels provide additional information on the Power BI line chart.

For example:

You need to check that January and July month sales are displayed on the line chart. At this time, the Data levels will help you.

1. Select your line chart -> click Format your visual -> click Visual -> Enable Data labels.

How to Get Data Labels in Power BI Line Chart

This way, you add data level to the Power BI Line Chart.

Zoom Slider in Power BI Line Chart

The Zoom slider increases or decreases the range of the numeric values on the y-axis in the Power BI Line Chart.

Follow the steps below to add Zoom Sliders on the Power BI Line chart axis:

1. Select your line chart -> click Format your visual -> click Visual -> Enable Zoom slicer.

How to add Zoom Sliders on Axis in Power BI Line Chart

This way, you can add a Zoom slider to the Power BI Line Chart on the axis.

Lines in Power BI Line Chart

Now, we will see how to apply line chart lines formatting in Power BI.

1. Select your line chart -> click Format your visual -> click Visual -> expand Lines.

Here, you will find two formatting options: Shape and Colors.

Format lines in Power BI line chart

2. Then expand the Shape. We can change the line style to DashedSolid, or Dotted. We can increase and decrease the line width. We can change the line type to Liner, Smooth, or Step.

Here, I want a Dashed line style, a line width of 5px, and a Smooth line type.

power bi smooth line in line chart

3. Then expand the Colors. We can change the line’s color in the Power BI Line chart.

Line Chart Lines Formatting in Power BI

This way, you can format the line in the Power BI Line Chart.

Plot area background in Power BI Line Chart

Now, we will see how to add a Plot area background in the power BI Line Chart.

1. Select your line chart -> click Format your visual -> click Visual -> Expand Plot area background.

Here, we can add an image and adjust the Transparency in the Power BI Line Chart image.

Insert Picture in Power BI Line Chart

This way, you can add plot area background in the power BI Line Chart.

Conclusion

I hope you follow all the steps for the Power BI Line chart. In this tutorial, we discussed what a line chart in Power BI is, how to create line chart in Power BI, and how to plot multiple lines on a Line chart in Power BI, Power BI Line chart multiple lines with Legend.

Also, we discussed how to add a secondary axis in the Power BI Line Chart and how to create small multiples in the Power BI Line chart.

Additionally, We discussed Power BI line chart formatting, like:

  • How to add Data Labels to a Power BI Line chart
  • Zoom Slider in Power BI Line chart
  • How to change the color lines in the Power BI Line chart
  • Use Plot area background in the Power BI Line chart

Moreover, you may like some more Power BI tutorials: