Power BI line chart allows you to add multiple lines which helps to compare different sets of data over time. This helps to identify trends, patterns, and relationships between the different datasets, providing deeper insights into your data.
Do you want to learn how to create multiple lines in a Power BI line chart? In this Power BI tutorial, we will see how to add multiple lines to the Power BI line chart.
Also, we will cover some of the below examples.
- Power BI line chart multiple lines for each year
- Power BI line chart multiple lines filter
How to create multiple lines in a Power BI line chart.
Here, we will see how to create multiple lines in a Power BI line chart.
For example, we will use the below Financial Excel sheet to create a Line chart.
We will display the sales and profit based on Segment in the line chart. Therefore, the sales and profit columns will be represented as two lines in the Power BI line chart, as shown below.
- Open Power BI Desktop, and then click on Get data -> select Excel Workbook. Or you can directly click on Excel Workbook.
Then select the Excel sheet from your local system; in the Navigator window, select the table and click on the Load button.
- Select the Line chart from the visualization pane to create a Line chart.
- To show the sales based on segment, drag and drop the Sales and Profit columns, and Segment columns to the Y and X-axis, respectively.
This is an example of a Power BI line chart with multiple lines.
Power BI line chart multiple lines for each year
Here, we will see how to display multiple lines for each year in the Power BI line chart.
For example, we will use the same sample Excel data, and we will use the columns Sales, Segment, and Year to show the sales trends for each year based on segment.
To display multiple lines for each year in the Power BI line chart. Follow the below steps:
- In Power BI Desktop, to create a line chart, from the visualization pane select the line chart.
- To show the sales for each year based on segment, drag and drop the Sales column, Segment column, and Year column to the Y, X-axis, and Legend, respectively.
This is how to display multiple lines for each year in the Power BI line chart.
Power BI line chart multiple lines filter
Here, we will see how to filter multiple lines in the Power BI line chart.
We will use the same financial sample data to display the sum of profit by year, month, and segment in the line chart. Then, we will create a slicer containing segment types. By selecting multiple segments from the slicer, the line chart will show the profits of those segments by year and month, which looks like the screenshot below.
- In Power BI Desktop, to create a line chart, from the visualization pane, select the line chart.
- To display the sum of profit by year, month, and segment in the line chart, Then drag and drop the profit, Date hierarchy[Year and month], and segment to the Y-axis, X-axis, and Legend.
- To filter multiple lines in the line chart, we will create a slicer; for this, click on the slicer from the visualization pane.
- Then, drag and drop the segment field to the Field.
- To select multiple segments from the slicer, press Ctrl and select the desired segments. This action will filter the lines in the Power BI line chart accordingly.
This is an example of how to filter multiple lines in a Power BI line chart.
Conclusion
In this Power BI tutorial, we saw how to create multiple lines in a Power BI line chart.
Also, we cover the different examples of Power BI line chart with multiple lines:
- Power BI line chart multiple lines for each year
- Power BI line chart multiple lines filter
You may also like:
- How to Show Zero Values in Power Bi Line Chart?
- Conditional Formatting in Power BI Line Chart
- Power BI Line Chart Date Hierarchy
After working for more than 18 years in Microsoft technologies like SharePoint, Microsoft 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (12 times). I have also worked in companies like HP, TCS, KPIT, etc.
