Title, labels, and legends in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ visualization

intermediate

Identify the Correct Title Placement for Accessibility

You create a bar chart in Power BI showing sales by region. You want the chart title to be clear and accessible for screen readers. Which option correctly sets the title for best accessibility?

A Add a text box above the chart with 'Sales by Region' and disable the visual title.

B Leave the title blank and rely on the axis labels only.

C Set the title text to 'Sales by Region' and enable the 'Title' toggle in the visual formatting pane.

D Use a legend to display 'Sales by Region' instead of a title.

💡 Hint

Think about how screen readers recognize chart titles.

Enabling the visual title with descriptive text ensures screen readers can identify the chart's purpose. Text boxes are not linked to visuals and won't be read as titles.

🧠 Conceptual

intermediate

Purpose of Legends in Data Visualizations

Why is a legend important in a Power BI chart that uses multiple colors to represent categories?

A It automatically filters data based on user clicks.

B It adds decorative colors to make the chart look more attractive.

C It replaces the need for axis labels entirely.

D It explains what each color or symbol in the chart represents, helping users understand the data.

💡 Hint

Think about how users know what each color means.

Legends provide a key to interpret colors or symbols in charts, making data easier to understand.

❓ dax_lod_result

advanced

DAX Measure for Dynamic Title Showing Selected Year

You want a dynamic title in Power BI that shows 'Sales in Year: <selected year>'. Which DAX measure produces the correct title when a single year is selected from a slicer?

Power BI

DynamicTitle =
VAR SelectedYear = SELECTEDVALUE('Calendar'[Year], "Multiple or None")
RETURN
"Sales in Year: " & SelectedYear

A "Sales in Year: " & VALUES('Calendar'[Year])

B "Sales in Year: " & SELECTEDVALUE('Calendar'[Year], "Multiple or None")

C CONCATENATE("Sales in Year: ", FIRSTNONBLANK('Calendar'[Year], 0))

D "Sales in Year: " & MAX('Calendar'[Year])

💡 Hint

Consider which function returns a single value or a default text.

SELECTEDVALUE returns the selected year if only one is selected; otherwise, it returns the default text. VALUES returns a table, causing an error in concatenation.

🔧 Formula Fix

advanced

Fixing Legend Display Issue in a Stacked Column Chart

You created a stacked column chart with categories and subcategories. The legend only shows the main categories, not subcategories. What is the most likely cause?

A The legend field is set only to the main category column, missing subcategories.

B The chart type does not support legends for subcategories.

C The data model has no relationship between categories and subcategories.

D The legend is disabled in the visual formatting pane.

💡 Hint

Check which field is assigned to the legend area.

The legend shows values from the field assigned to it. If only main categories are assigned, subcategories won't appear in the legend.

🎯 Scenario

expert

Designing a Dashboard with Clear Titles, Labels, and Legends

You are designing a sales dashboard for non-technical users. The dashboard includes multiple charts with different measures and categories. Which combination of title, labels, and legend practices ensures the dashboard is easy to understand?

A Use descriptive chart titles, label axes clearly with units, and include legends with clear category names and contrasting colors.

B Use short titles, hide axis labels to reduce clutter, and remove legends to simplify visuals.

C Use generic titles like 'Chart 1', use axis labels only when necessary, and use legends only for pie charts.

D Use no titles, rely on tooltips for labels, and use legends with many colors regardless of contrast.

💡 Hint

Think about clarity and ease of understanding for all users.

Clear titles, axis labels with units, and well-designed legends with contrasting colors help users quickly understand the data without confusion.

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