Line charts in Power BI - Dashboard Guide

Dashboard Mode - Line charts

Dashboard Goal

Track monthly sales trends over the first half of the year to identify growth patterns and seasonal changes.

Sample Data

Month	Sales
January	100
February	150
March	130
April	170
May	160
June	200

Dashboard Components

• KPI Card: Total Sales
  Formula: Total Sales = SUM(SalesData[Sales])
  Result: 910
• Line Chart: Monthly Sales Trend
  X-axis: Month (January to June)
  Y-axis: Sales
  Data points: 100, 150, 130, 170, 160, 200
  Shows sales increasing with some fluctuations over months

Dashboard Layout

+----------------------+---------------------+
|      KPI Card        |    Line Chart       |
|  Total Sales: 910    |  Monthly Sales Trend|
+----------------------+---------------------+

Interactivity

A slicer for selecting months allows filtering the line chart and KPI card. For example, selecting January to March updates the total sales to 380 and the line chart to show only those months.

Self Check

If you add a filter to show only sales from April to June, which components update and what is the new total sales?

Answer: Both the KPI card and the line chart update. The new total sales is 530 (170 + 160 + 200).

Key Result

A dashboard showing total sales and monthly sales trends from January to June using a KPI card and a line chart.

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