Selecting Visualizations for Geographic, Categorical, and Temporal Data

DA0-002 By islever Editorial Last updated

Create effective visuals Communicate analysis results

Short answer

Use a Map chart for 'County outages' with no standard X/Y axis labels; use a Bar/Column chart for 'Status' with X-Axis as County and Y-Axis as Number of Outages; use a Line chart for 'Trend' with X-Axis as Date and Y-Axis as Number of Outages.

Question

HOTSPOT
The director of operations at a power company needs data to help identify where company resources should be allocated in order to monitor activity for outages and restoration of power in the entire state. Specifically, the director wants to see the following:
County outages
Status
Overall trend of outages
INSTRUCTIONS
select each visualization to fit the appropriate space on the dashboard. Once you have selected all visualizations, use the drop-down menus to select the appropriate dashboard titles and axis labels, if applicable.
If at any time you would like to bring back the initial state of the simulation, please click the Reset All button.
Exhibit: Selecting Visualizations for Geographic, Categorical, and Temporal
Exhibit: Selecting Visualizations for Geographic, Categorical, and Temporal
Exhibit: Selecting Visualizations for Geographic, Categorical, and Temporal

Key Takeaways

The main trap is misidentifying the data type: geographic data needs a map, categorical comparisons need bars, and time-series trends need lines.

This page explains how to select the correct visualization type—Map, Bar Chart, and Line Chart—for geographic, categorical, and temporal data respectively in a Power BI dashboard scenario.

Common mistake: Learners often incorrectly assign a Pie Chart to 'Status' because it shows parts of a whole, but a Bar Chart is better for comparing counts across multiple counties. Another mistake is using a Scatter Plot for trends, which is for correlation, not time-series.

Expert Analysis

The scenario requires mapping three specific data requirements to appropriate visualization types and dashboard configurations. The core concept tested is Data Visualization Selection (Objective 4.1), specifically distinguishing between spatial, categorical, and temporal data representations.

First, the requirement for "County outages" implies a need to show geographic distribution. A Map chart is the correct choice here, as it plots data points on a geographic area. The dashboard title should reflect this scope, such as "Power Outages Region-wide," and since maps do not use traditional X/Y axes in the same way bar charts do, axis labels are typically omitted or handled via legend/tooltip context rather than explicit axis titles.

Second, the requirement for "Status" involves comparing discrete categories (e.g., Outage, Restored, Investigating) across different counties. A Bar chart or Column chart is ideal for comparing values across categorical dimensions. The dashboard title would be "Status of Incidents by County." The X-axis represents the categories (County), and the Y-axis represents the measure (Number of Outages or Status Count).

Third, the requirement for "Overall trend of outages" over time necessitates a Line chart or Area chart, which are designed to show changes and trends over a continuous period (Date). The dashboard title could be "Power Outages in the Quarter." The X-axis must represent Time (Date), and the Y-axis represents the metric (Number of Outages).

Comments from learners confirm this mapping: they identify the map for geographic area, the bar/column chart for county status comparison, and the line chart for date-based trends. The key trap is confusing the axis labels or choosing a pie chart for status (which doesn't compare magnitudes well across many counties) or a scatter plot for trends.

Exam Strategy

Always classify your data dimension first: Is it Spatial (use Map), Categorical/Discrete (use Bar/Column), or Temporal/Continuous (use Line/Area). Then match the chart to the analytical goal: location (Map), comparison (Bar), or trend (Line). Avoid Pie Charts for complex categorical comparisons.

Frequently Asked Questions

Why not use a Pie Chart for outage status?

Pie charts are best for showing parts of a whole with few categories. For comparing outage status across many counties, a Bar Chart allows easier visual comparison of magnitudes.

What if the trend data is not daily?

A Line Chart still works for weekly or monthly trends as long as the X-axis represents a continuous time scale. The key is showing change over time.

More DA0-002 FAQ →

Discussion 1 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 1

  1. 6b7911d 👍 1
    So everyone has a simplified view: In this format: TAB:E NAME - X Axis: ANSWER, Y Axis: ANSWER Dashboard Title - Power Outages Region-wide Geographic Area of Outages - X Axis: County, Y Axis: Number of Outages Status of Incidents by County - X Axis: County, Y Axis: Status of Incidents Power Outages in the Quarter - X Axis: Date, Y Axis: Number of Outages

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Practice All DA0-002 Questions

Access 100 questions with complete answers and detailed explanations.

View Full DA0-002 Practice Test →

← Back to DA0-002 Study Guide