Bird
0
0

You want to show monthly sales and highlight months where sales exceeded targets. Which visual and feature combination is best?

hard📝 Scenario Q8 of 15
Power BI - Basic Visualizations
You want to show monthly sales and highlight months where sales exceeded targets. Which visual and feature combination is best?
APie chart with legend
BLine chart without markers
CClustered column chart with conditional formatting
DTable visual with no filters
Step-by-Step Solution
Solution:
  1. Step 1: Identify need to compare and highlight

    Showing monthly sales and highlighting specific months requires clear category comparison and color cues.
  2. Step 2: Choose visual and feature

    Clustered column charts show monthly values side by side; conditional formatting highlights target-exceeding months.
  3. Final Answer:

    Clustered column chart with conditional formatting -> Option C
  4. Quick Check:

    Highlighting with colors = Conditional formatting on column chart [OK]
Quick Trick: Use conditional formatting to highlight key data [OK]
Common Mistakes:
  • Using pie charts for time series
  • Choosing line charts without highlights
  • Using tables without visual emphasis

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Power BI Quizzes