Power BI - Formatting and Design
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?
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📝 Scenario Q15 of 15
Step-by-Step Solution
Solution:
Step 1: Match title to chart purpose
The title 'Monthly Sales by Category' clearly explains the chart's content.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).Step 3: Evaluate other options
Other options mix up axis labels or omit legend, reducing clarity.Final Answer:
Title: 'Monthly Sales by Category'; X-axis label: 'Month'; Y-axis label: 'Sales Amount'; Legend: Product Category -> Option CQuick Check:
Clear title + correct labels + legend = Title: 'Monthly Sales by Category'; X-axis label: 'Month'; Y-axis label: 'Sales Amount'; Legend: Product Category [OK]
Quick Trick: 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
Master "Formatting and Design" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes