0
0
Power BIbi_tool~15 mins

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

Choose your learning style9 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.