Title, labels, and legends in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to add a title to a Power BI visual.

Power BI

Visual.Title.Text = "[1]"

Drag options to blanks, or click blank then click option'

ASales Overview

BChart Axis

CData Table

DLegend

Attempts:

3 left

💡 Hint

Common Mistakes

Using labels or legends as the title text.

Leaving the title blank.

The title of a visual should clearly describe what the visual shows. "Sales Overview" is a good descriptive title.

2fill in blank

medium

Complete the code to set the X-axis label in a Power BI chart.

Power BI

Visual.XAxis.Title.Text = "[1]"

Drag options to blanks, or click blank then click option'

AMonth

BRevenue

CCategory

DTotal

Attempts:

3 left

💡 Hint

Common Mistakes

Using a measure name instead of a category for the X-axis label.

Confusing X-axis label with Y-axis label.

The X-axis usually represents categories or time periods. "Month" is a common label for the X-axis in time series charts.

3fill in blank

hard

Fix the error in the code to correctly display the legend title.

Power BI

Visual.Legend.Title.Text = "[1]"

Drag options to blanks, or click blank then click option'

ALegendLabel

BLegends

CLegend Title

DLegend

Attempts:

3 left

💡 Hint

Common Mistakes

Using plural form "Legends" which is invalid.

Using incorrect property names like "LegendLabel".

The correct property to set the legend title text is "Legend Title". Other options are either plural or incorrect property names.

4fill in blank

hard

Fill both blanks to set the Y-axis label and enable the legend in a Power BI visual.

Power BI

Visual.YAxis.Title.Text = "[1]"
Visual.Legend.Visible = [2]

Drag options to blanks, or click blank then click option'

ASales

BTrue

CFalse

DProfit

Attempts:

3 left

💡 Hint

Common Mistakes

Setting legend visibility to False when it should be shown.

Using a category name instead of a measure for Y-axis label.

The Y-axis label should describe the measure, such as "Sales". To show the legend, set Visible to True.

5fill in blank

hard

Fill all three blanks to set the chart title, X-axis label, and disable the legend.

Power BI

Visual.Title.Text = "[1]"
Visual.XAxis.Title.Text = "[2]"
Visual.Legend.Visible = [3]

Drag options to blanks, or click blank then click option'

AMonthly Revenue

BMonth

CFalse

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing the X-axis label with the Y-axis label.

Setting legend visibility to True when it should be hidden.

The chart title should describe the data, e.g., "Monthly Revenue". The X-axis label is "Month". To hide the legend, set Visible to False.

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