Title, labels, and legends in Power BI - Dashboard Guide

Dashboard Mode - Title, labels, and legends

Business Question

How can we clearly show monthly sales data with meaningful titles, axis labels, and legends to help users understand the chart easily?

Sample Data

Month	Product	Sales
January	Apples	120
January	Bananas	80
February	Apples	150
February	Bananas	90
March	Apples	130
March	Bananas	100

Dashboard Components

• KPI Card: Total Sales
  Formula: Total Sales = SUM(Sales[Sales])
  Result: 670
• Clustered Column Chart: Monthly Sales by Product
  Details:
  • Title: "Monthly Sales by Product"
  • X-axis label: "Month"
  • Y-axis label: "Sales Amount"
  • Legend: "Product" (shows Apples and Bananas)

Dashboard Layout

+-----------------------------+
|        Total Sales KPI       |
+-----------------------------+
|                             |
|  Monthly Sales by Product    |
|  [Clustered Column Chart]    |
|                             |
+-----------------------------+

Interactivity

A slicer for Month allows users to select one or multiple months. When a month is selected, both the Total Sales KPI and the Clustered Column Chart update to show data only for the selected months.

Self Check

If you add a filter to show only February, what will the Total Sales KPI show? What products appear in the legend of the chart?

Answer: Total Sales KPI will show 240 (150 + 90). The legend will show both Apples and Bananas since both have sales in February.

Key Result

Dashboard shows total sales and monthly sales by product with clear titles, axis labels, and legends.

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