Line charts in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a line chart used for in Power BI?

A line chart shows trends over time or ordered categories by connecting data points with a line. It helps see how values change.

beginner

How do you add a line chart in Power BI?

Select the line chart icon from the Visualizations pane, then drag fields to the Axis and Values areas.

intermediate

Why should you use a continuous axis in a line chart for dates?

A continuous axis shows smooth time progression without gaps, making trends easier to understand.

intermediate

What is a common mistake when using line charts?

Using line charts for categorical data without order can confuse viewers because lines imply order or progression.

beginner

How can you improve accessibility in line charts?

Use clear labels, high contrast colors, and provide alternative text descriptions for screen readers.

What does a line chart best show?

A Individual data points only

B Parts of a whole

C Trends over time

D Data distribution

Line charts connect points to show how values change over time or ordered categories.

Which axis type is best for dates in a line chart?

A Categorical

B Discrete

C Logarithmic

D Continuous

Continuous axis shows smooth progression of dates without gaps.

What happens if you use a line chart for unordered categories?

A It may confuse viewers

B It clearly shows trends

C It shows parts of a whole

D It creates a pie chart

Lines imply order, so unordered categories can confuse the viewer.

Which Power BI pane lets you add a line chart?

A Visualizations

B Fields

C Filters

D Data

The Visualizations pane contains the line chart icon to add it to the report.

How can you make line charts more accessible?

A Use low contrast colors

B Add alternative text and clear labels

C Avoid labels

D Use many colors without explanation

Clear labels, high contrast, and alt text help all users understand the chart.

Explain how to create a line chart in Power BI and why you would use it.

Think about the steps in the Visualizations pane and the purpose of line charts.

Describe best practices for using line charts effectively and accessibly.

Consider what makes a line chart easy to read and understand for everyone.

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