Title, labels, and legends in Power BI - Cell-by-Cell Formula Trace

Sample Data

Monthly sales data for the first quarter

Cell	Value
A1	Month
B1	Sales
A2	Jan
B2	100
A3	Feb
B3	150
A4	Mar
B4	120

Formula Trace

Add chart title 'Quarter 1 Sales', X-axis label 'Month', Y-axis label 'Sales', and legend for Sales series

Step 1: Select chart visual

Step 2: Add chart title 'Quarter 1 Sales'

Step 3: Set X-axis label to 'Month'

Step 4: Set Y-axis label to 'Sales'

Step 5: Enable legend for Sales series

Cell Reference Map

    A       B
1 | Month | Sales |
2 |  Jan  |  100  |
3 |  Feb  |  150  |
4 |  Mar  |  120  |

Arrows:
B column feeds Sales data into chart
A column feeds Month labels into chart

The chart uses column A for X-axis labels (Month) and column B for Y-axis values (Sales)

Result

Chart: Quarter 1 Sales

Legend: Sales

X-axis: Month (Jan, Feb, Mar)
Y-axis: Sales (100, 150, 120)

[Bar chart with 3 bars labeled Jan, Feb, Mar with heights 100, 150, 120]

The chart shows monthly sales with a clear title, axis labels, and a legend identifying the Sales data series

Sheet Trace Quiz - 3 Questions

What does the chart title 'Quarter 1 Sales' describe?

A The label for the Y-axis

B The label for the X-axis

C The overall topic of the chart

D The name of the legend

Key Result

Add descriptive titles, axis labels, and legends to charts for clarity

Practice

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

easy

A. To explain what the whole chart or report is about

B. To show the values on the vertical axis

C. To display the color codes for categories

D. To filter the data shown in the chart

Solution

1. Step 1: Understand the role of a title

   A title gives a clear explanation of what the entire chart or report represents.

2. Step 2: Compare with other elements

   Labels show axis data, legends show categories, but only the title explains the chart's overall meaning.

3. Final Answer:

   To explain what the whole chart or report is about -> Option A

4. Quick Check:

   Title = Chart explanation [OK]

Hint: Titles describe the whole chart clearly [OK]

Common Mistakes:

• Confusing title with axis labels
• Thinking legend is the title
• Assuming title filters data

2. Which of the following is the correct way to add a legend in a Power BI chart?

easy

A. Drag a field to the Legend area in the Visualizations pane

B. Type the legend text directly on the chart

C. Add a title to the chart

D. Change the axis labels to colors

Solution

1. Step 1: Identify how legends are added

   In Power BI, legends are created by dragging a field into the Legend area of the Visualizations pane.

2. Step 2: Eliminate incorrect options

   Typing text or changing axis labels does not create legends; adding a title is unrelated.

3. Final Answer:

   Drag a field to the Legend area in the Visualizations pane -> Option A

4. Quick Check:

   Legend = Field in Legend area [OK]

Hint: Drag fields to Legend area to add legends [OK]

Common Mistakes:

• Trying to type legend manually
• Confusing legend with title
• Changing axis labels to create legend

3. Given a bar chart with sales data by region, which visual element helps you quickly identify which color represents each region?

medium

A. Axis labels

B. Legend

C. Title

D. Data labels

Solution

1. Step 1: Understand the role of each element

   The title explains the chart, axis labels show data scale, data labels show values, but the legend links colors to categories.

2. Step 2: Identify the element linking colors to regions

   The legend shows which color corresponds to each region in the chart.

3. Final Answer:

   Legend -> Option B

4. Quick Check:

   Legend = Color-category guide [OK]

Hint: Legends match colors to categories [OK]

Common Mistakes:

• Confusing axis labels with legend
• Thinking title shows colors
• Ignoring data labels' role

4. You created a line chart but the legend is missing. What is the most likely reason?

medium

A. Data labels are overlapping

B. The chart title is empty

C. Axis labels are turned off

D. No field was added to the Legend area

Solution

1. Step 1: Check legend setup

   Legends appear only if a field is assigned to the Legend area in the Visualizations pane.

2. Step 2: Rule out other causes

   Empty titles or axis labels do not remove legends; overlapping data labels affect values, not legends.

3. Final Answer:

   No field was added to the Legend area -> Option D

4. Quick Check:

   Legend missing = No field in Legend area [OK]

Hint: Add field to Legend area to show legend [OK]

Common Mistakes:

• Assuming title controls legend
• Thinking axis labels hide legend
• Confusing data labels with legend

5. You want to create a sales report with a bar chart that shows monthly sales by product category. Which combination of title, labels, and legend settings is best for clarity?

hard

A. Title: 'Sales'; X-axis label: 'Category'; Y-axis label: 'Month'; Legend: None

B. Title: None; X-axis label: 'Sales Amount'; Y-axis label: 'Month'; Legend: Product Category

C. Title: 'Monthly Sales by Category'; X-axis label: 'Month'; Y-axis label: 'Sales Amount'; Legend: Product Category

D. Title: 'Monthly Sales'; X-axis label: 'Sales Amount'; Y-axis label: 'Product Category'; Legend: Month

Solution

1. Step 1: Match title to chart purpose

   The title 'Monthly Sales by Category' clearly explains the chart's content.

2. Step 2: Assign correct axis labels and legend

   X-axis should show 'Month' (time), Y-axis 'Sales Amount' (values), and legend should identify 'Product Category' (color groups).

3. Step 3: Evaluate other options

   Other options mix up axis labels or omit legend, reducing clarity.

4. Final Answer:

   Title: 'Monthly Sales by Category'; X-axis label: 'Month'; Y-axis label: 'Sales Amount'; Legend: Product Category -> Option C

5. Quick Check:

   Clear title + correct labels + legend = Title: 'Monthly Sales by Category'; X-axis label: 'Month'; Y-axis label: 'Sales Amount'; Legend: Product Category [OK]

Hint: Title explains chart; axes show data; legend shows categories [OK]

Common Mistakes:

• Swapping axis labels
• Omitting legend when categories exist
• Using unclear or missing titles