Line charts in Power BI - Step-by-Step Guide

Introduction

Line charts show how data changes over time or categories. They help you see trends and patterns clearly by connecting data points with lines.

When you want to show sales growth month by month.

When you need to compare temperature changes over days.

When tracking website visitors daily to see traffic trends.

When showing stock prices movement over weeks.

When visualizing progress of a project over time.

Steps

Step 1: Click

- Report view pane

The report canvas is active and ready for visuals

Step 2: Select

- Visualizations pane > Line chart icon

A blank line chart placeholder appears on the canvas

Step 3: Drag

- Fields pane > Date or Category field

The field is added to the Axis area of the line chart

💡 Use a date field for time-based trends

Step 4: Drag

- Fields pane > Numeric value field (e.g., Sales Amount)

The field is added to the Values area and data points appear connected by lines

Step 5: Click

- Format pane > Data colors

You can customize the line color to improve clarity

Step 6: Click

- Format pane > X-axis

You can adjust axis labels, title, and scale for better readability

Before vs After

Before

Blank report canvas with no visuals

After

Line chart on canvas showing monthly sales trend with connected points and labeled axes

Settings Reference

Data colors

📍 Format pane > Data colors

Change line colors to differentiate data series

Default: Automatic color assigned by Power BI

X-axis

📍 Format pane > X-axis

Customize how the horizontal axis looks and behaves

Default: On with automatic settings

Y-axis

📍 Format pane > Y-axis

Control vertical axis appearance and range

Default: On with automatic scaling

Data labels

📍 Format pane > Data labels

Show or hide values on each data point

Default: Off

Common Mistakes

Using a non-date field on the axis for time trends

It breaks the time sequence and confuses the trend line

Always use a date or properly ordered category field on the axis

Adding too many data series to one line chart

The chart becomes cluttered and hard to read

Limit lines to a few key series or use filters to focus

Not formatting axes labels and titles

Users may not understand what the chart shows

Add clear axis titles and format labels for clarity

Summary

Line charts connect data points to show trends over time or categories.

Use date fields on the axis for time-based data to keep order.

Customize colors and axis labels to make the chart clear and readable.

Practice

1. What is the main purpose of a line chart in Power BI?

easy

A. To list raw data values in a table format

B. To display data as separate categories without order

C. To show trends and changes over time or order

D. To compare parts of a whole using slices

Solution

1. Step 1: Understand the function of line charts

   Line charts are designed to show how data changes over time or a sequence.

2. Step 2: Compare with other chart types

   Other charts like pie charts show parts of a whole, tables show raw data, and bar charts show categories without order.

3. Final Answer:

   To show trends and changes over time or order -> Option C

4. Quick Check:

   Line chart = trends over time [OK]

Hint: Line charts always show data changes over time or order [OK]

Common Mistakes:

• Confusing line charts with pie charts
• Using line charts for unordered categories
• Thinking line charts show raw data tables

2. Which of the following is the correct way to set up a line chart in Power BI?

easy

A. Place numeric values on the X-axis and dates on the Y-axis

B. Place a date or ordered category on the X-axis and numeric values on the Y-axis

C. Use only text categories on both axes

D. Use a pie chart visual instead of a line chart

Solution

1. Step 1: Identify axis roles in line charts

   The X-axis should have dates or ordered categories to show progression, and the Y-axis should have numeric values to show changes.

2. Step 2: Eliminate incorrect setups

   Numeric values on X-axis or text-only axes do not show trends properly; pie charts are a different visual type.

3. Final Answer:

   Place a date or ordered category on the X-axis and numeric values on the Y-axis -> Option B

4. Quick Check:

   X-axis = date/order, Y-axis = values [OK]

Hint: X-axis = time/order, Y-axis = numbers for line charts [OK]

Common Mistakes:

• Swapping X and Y axis roles
• Using text categories on both axes
• Choosing wrong visual type

3. Given this data for sales over months: January=100, February=150, March=120, what will the line chart show for March compared to February?

medium

A. A point lower than February

B. A point higher than February

C. A point equal to February

D. No point for March

Solution

1. Step 1: Compare March and February sales values

   March sales are 120, which is less than February's 150.

2. Step 2: Understand line chart plotting

   The line chart plots points on the Y-axis by value; March's point will be lower than February's.

3. Final Answer:

   A point lower than February -> Option A

4. Quick Check:

   120 < 150 means March point lower [OK]

Hint: Lower value means lower point on line chart [OK]

Common Mistakes:

• Assuming March is higher than February
• Confusing equal values
• Thinking March data is missing

4. You created a line chart but it shows all points as a flat line at zero. What is the most likely cause?

medium

A. The data has negative values only

B. The date field is on the Y-axis instead of X-axis

C. The chart type is set to pie chart by mistake

D. The numeric values field is missing or contains zeros

Solution

1. Step 1: Check numeric values field in the chart

   If the values field is missing or all zeros, the line will be flat at zero.

2. Step 2: Verify axis and chart type

   Having date on Y-axis or wrong chart type would cause different errors, not flat zero line; negative values still plot below zero.

3. Final Answer:

   The numeric values field is missing or contains zeros -> Option D

4. Quick Check:

   Missing or zero values cause flat line [OK]

Hint: Check if values field is empty or zero-filled [OK]

Common Mistakes:

• Ignoring missing values field
• Confusing axis placement errors
• Assuming negative values cause flat line

5. You want to compare sales trends for two products over the same months using a line chart. What is the best way to set this up in Power BI?

hard

A. Place months on X-axis, sales on Y-axis, and use product as Legend to show separate lines

B. Place sales on X-axis, months on Y-axis, and filter by product one at a time

C. Create two separate line charts, one for each product, and place side by side

D. Use a pie chart to compare sales of both products

Solution

1. Step 1: Understand how to show multiple lines in one chart

   Using the Legend field with product categories creates separate lines for each product on the same chart.

2. Step 2: Confirm axis roles for trend comparison

   Months go on X-axis to show time order, sales on Y-axis to show values, and product in Legend to differentiate lines.

3. Final Answer:

   Place months on X-axis, sales on Y-axis, and use product as Legend to show separate lines -> Option A

4. Quick Check:

   Legend = product for multiple lines [OK]

Hint: Use Legend for categories to show multiple lines [OK]

Common Mistakes:

• Swapping X and Y axes
• Using separate charts instead of Legend
• Choosing wrong chart type