Bird
Raised Fist0
Power BIbi_tool~15 mins

Title, labels, and legends in Power BI - Real Business Scenario

Choose your learning style10 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Scenario Mode
šŸ‘¤ Your Role: You are a sales analyst at a retail company.
šŸ“‹ Request: Your manager wants a clear sales report that shows monthly sales by product category. The report should have a descriptive title, clear axis labels, and a legend to identify product categories.
šŸ“Š Data: You have monthly sales data for three product categories: Electronics, Clothing, and Home Goods. The data includes the month, product category, and sales amount.
šŸŽÆ Deliverable: Create a Power BI bar chart showing monthly sales by product category with a clear title, axis labels, and a legend.
Progress0 / 8 steps
Sample Data
MonthProduct CategorySales Amount
JanuaryElectronics12000
JanuaryClothing8000
JanuaryHome Goods6000
FebruaryElectronics15000
FebruaryClothing7000
FebruaryHome Goods6500
MarchElectronics13000
MarchClothing9000
MarchHome Goods7000
1
Step 1: Load the sales data into Power BI by importing the table with columns Month, Product Category, and Sales Amount.
Use 'Get Data' > 'Excel' or 'CSV' depending on your file format, then load the data.
Expected Result
Sales data is loaded and visible in the Fields pane.
2
Step 2: Create a clustered bar chart visual.
From the Visualizations pane, select the 'Clustered bar chart' icon.
Expected Result
A blank clustered bar chart appears on the report canvas.
3
Step 3: Add 'Month' to the Axis field well.
Drag the 'Month' field to the Axis area of the visual.
Expected Result
Months appear on the vertical axis of the bar chart.
4
Step 4: Add 'Sales Amount' to the Values field well.
Drag the 'Sales Amount' field to the Values area of the visual.
Expected Result
Bars show the total sales amount for each month.
5
Step 5: Add 'Product Category' to the Legend field well.
Drag the 'Product Category' field to the Legend area of the visual.
Expected Result
Bars are colored by product category, and a legend appears identifying each category.
6
Step 6: Add a descriptive title to the chart.
Select the visual, go to the Format pane > Title, turn it on, and enter 'Monthly Sales by Product Category'.
Expected Result
The chart displays the title 'Monthly Sales by Product Category' above it.
7
Step 7: Add axis labels for clarity.
In the Format pane, expand 'X-axis' and 'Y-axis', turn on 'Title' for each, and set X-axis title to 'Sales Amount' and Y-axis title to 'Month'.
Expected Result
The horizontal axis is labeled 'Sales Amount' and the vertical axis is labeled 'Month'.
8
Step 8: Ensure the legend is visible and clear.
In the Format pane, expand 'Legend', turn it on, set position to 'Right', and verify category colors and labels.
Expected Result
A clear legend appears on the right side showing Electronics, Clothing, and Home Goods with distinct colors.
Final Result
Monthly Sales by Product Category

Month      |ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā–  Electronics
           |ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā–  Clothing
           |ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā– ā–  Home Goods

           +-------------------------------------------------------> Sales Amount
            January   February   March

Legend:
ā–  Electronics
ā–  Clothing
ā–  Home Goods
āœ“Electronics consistently have the highest sales each month.
āœ“Clothing sales are moderate but steady.
āœ“Home Goods have the lowest sales among the three categories.
Bonus Challenge

Add data labels to each bar segment to show exact sales amounts.

Show Hint
Select the chart, go to Format pane > Data labels, turn them on, and adjust font size and color for readability.

Practice

(1/5)
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
Recommended

Ready to prove it?

Pass the test and this pattern moves unknown strong while earning +1 Grip toward your certificate.

10 questions~5 mineasy hard