Wednesday, December 13, 2023

Lesson 13 - Line chart in Power BI Desktop

A line chart is a type of graph that shows how something changes over time. Data points in the line chart represent the individual values at specific points in time or in a continuous interval. These data points are then connected with lines to illustrate how the values change or trend over the period.

How to Proceed?

Step 1
Launch power BI desktop app and open the new report page and import the data required. 

Step 2
In “Visualizations” pane click on “Line chart” which is highlighted in the given figure. 

Step 3
Drag the data fields into “Field Section “that we want to compare and analyze. 

X axis:  Represent categories – Year
Y axis: Shows the Count of medal

The legend represents the different data series or categories which helps us to understand which line corresponds to which data elements.

Here we are showing different types of medals (Gold, silver, bronze) count by Year.

Step 4:

Filters in Power BI allows us to control and shape the data as per our needs. Here we are showing the page level filter where we can display only the data we want to show in reports or dashboards. By slicing and dicing the data we can gain insights from it.

Here, we used filters in medal (Filtered only Gold, Bronze and Silver) and in Region (Top 10 countries by medal count).

Step 5:

Customizing the appearance of Line chart

You can customize the appearance of the visual.  You can change Title, Font size, Style, Colours and Data labels. 
Click anywhere on the visual and set the below properties in the Format section.

In this visual, I chose background colour as blue and gave 87% transparency which reduces the intensity of the colour.

Give suitable title for the visual and customize the font size, colour and position of the title.

Chose colours for the line to show different categories.
To add data labels to the Line chart, click on the “Data Labels” section under “Visual”. Here you can choose which data to display in the labels and adjust their position, font, and color. 

In this visual, to place the position of data labels. Under formatting visuals, click on data labels and choose the desired options.
Here for this visual, we used “Above” option to display the data.

Step 6 Save the visual

Finally, your Line chart is ready. Click save button to save the visual. 

When to use Line chart?

Line chart are most appropriate when we want to visualize trends, changes over time, and to display continuous data, compare different categories

  • Line charts are generally simple and easy to understand the visual which makes easily accessible to everyone
  • It is great in showing changes of data over time and patterns in a clear manner.
  • In line chart we can clearly identify when the data goes up or down which helps in spotting important changes
  • Line chart can be used only to show changes over time, it will not be suitable to show other types of data
  • With too many data points, the line chart become clumsy and difficult to read the data


Line charts are great for showing trends or comparing things over time, but it may not work well for all types of data.

Tags Power BI
Useful links
MS Learn Modules
Test Your Knowledge Quiz

No comments:

Post a Comment