Microsoft Power BI Quiz: Choosing Visuals
10 questions · exam conditions
0:00
Choosing VisualsQuestion 1 of 10

A sales report contains monthly revenue, a monthly revenue target, and a variance measure. Executives must quickly identify months that missed the target while also comparing the magnitude of actual revenue between months. The report should use a single visual and should not require users to inspect tooltips.

Which visual should you use?

A line and clustered column chart with actual revenue as columns and the target as a line
A stacked column chart with actual revenue and the target stacked for each month
A line chart with actual revenue, the target, and variance shown as three lines
A waterfall chart that starts with the target and adds each month's revenue variance
← Back to quizzes

Microsoft Power BI Quiz

Microsoft Power BI Quiz: Choosing Visuals

Practice Choosing Visuals in Microsoft Power BI with focused quiz questions that help you check what you know, review explanations, and build confidence with test-style prompts.

What this quiz covers

This quiz focuses on Choosing Visuals, giving you a quick way to practice the rules, question types, and explanations that matter most for Microsoft Power BI.

How to use this quiz

Try each quiz question before looking at the correct answer. Use the explanations to review missed ideas, then come back to similar questions until the pattern feels familiar.

All questions

Question 1

A sales report contains monthly revenue, a monthly revenue target, and a variance measure. Executives must quickly identify months that missed the target while also comparing the magnitude of actual revenue between months. The report should use a single visual and should not require users to inspect tooltips.

Which visual should you use?

  1. A line and clustered column chart with actual revenue as columns and the target as a line (correct answer)
  2. A stacked column chart with actual revenue and the target stacked for each month
  3. A line chart with actual revenue, the target, and variance shown as three lines
  4. A waterfall chart that starts with the target and adds each month's revenue variance
Explanation: When a question asks you to compare actual versus target values and show magnitude differences across categories in a single visual — without tooltips — think about which chart types encode both a comparison line and bar magnitudes simultaneously. A line and clustered column chart (A) is purpose-built for exactly this scenario. The columns represent actual monthly revenue, making it visually straightforward to compare bar heights across months. The target sits as an overlaid line, so executives can instantly see which months fall below it without hovering over anything. Both pieces of information — magnitude comparison and target miss identification — are visible at a glance. This is the correct choice. B falls into a trap: stacking actual revenue and the target creates a combined height that's meaningless. Stacked charts are for part-to-whole relationships, not target comparisons. Executives would struggle to identify misses because the target bar segment sits on top of revenue rather than crossing it as a reference. C uses three lines for revenue, target, and variance. While revenue versus target is readable, showing variance as a third line duplicates information already implied by the gap between the first two lines. More critically, comparing magnitude of revenue across months is harder with lines than with bars — lines emphasize trend, not absolute size. D, a waterfall chart, is designed to show cumulative effects of sequential increases and decreases. Starting from the target and adding variances distorts the actual monthly revenue values, making magnitude comparisons between months confusing rather than clear. Study tip: On Power BI visuals questions, match the dual purpose of a visual to the requirement — combo charts exist precisely when you need both a categorical magnitude comparison (columns) and a reference benchmark (line).

Question 2

A marketing analyst wants to determine whether advertising spend is associated with sales revenue across individual campaigns. The analyst also wants to identify outlying campaigns and represent the number of impressions as a third quantitative variable.

Which visual should you choose?

  1. A scatter chart with spend and revenue on the axes and impressions controlling bubble size (correct answer)
  2. A line chart with separate lines for spend, revenue, and impressions by campaign name
  3. A clustered column chart with spend and revenue as columns and impressions as a tooltip
  4. A treemap grouped by campaign with revenue as area and spend controlling color saturation
Explanation: When a question asks you to show the relationship between two quantitative variables, identify outliers, and encode a third quantitative variable, you're being tested on your knowledge of scatter and bubble charts — Power BI's go-to visuals for correlation analysis. A scatter chart plots two numeric axes against each other, making it ideal for revealing whether advertising spend and revenue move together across campaigns. When you enable the Play Axis or simply drag a third numeric field to the Size well, each data point becomes a bubble whose area reflects that value — in this case, impressions. This is exactly what answer A describes, making it the correct choice. You get correlation visibility, outlier detection, and a third dimension of data all in one view. Answer B (line chart) is wrong because line charts imply a continuous trend over time or sequential categories. Plotting spend, revenue, and impressions as separate lines obscures any relationship between those variables — you can't see if spend and revenue correlate with each other. Answer C (clustered column chart) compares magnitudes side by side but doesn't reveal correlation. Hiding impressions in a tooltip also removes it as a visible, comparative dimension, defeating the analyst's goal of representing it. Answer D (treemap) encodes hierarchy and part-to-whole relationships using area and color. While it can display two variables, it is fundamentally the wrong chart type for correlation analysis and outlier identification. Study tip: Whenever a question mentions "relationship between two variables" plus a "third quantitative variable," immediately think bubble chart — it's Power BI's dedicated tool for that exact three-variable scenario.

Question 3

A customer-acquisition report tracks five acquisition channels by month. Management wants to compare how each channel's percentage of all new customers changes over time. Monthly customer totals vary substantially, but those total-volume changes are not part of the analytical question.

Which visual most directly answers the analytical question?

  1. A stacked area chart using the number of new customers for each acquisition channel
  2. A clustered column chart using the number of new customers for each channel by month
  3. A 100% stacked column chart using channel as the legend and month as the axis (correct answer)
  4. A line chart using one line for total customers and one line for each channel
Explanation: When a question asks you to compare proportions over time — not raw counts — your first instinct should be to look for a chart type that normalizes the data to 100%. That's the core concept being tested here. A 100% stacked column chart (C) converts each month's absolute customer counts into percentages that sum to 100%, making each channel's share directly visible regardless of how much total volume fluctuates month to month. Since management explicitly wants to track percentage of all new customers and doesn't care about total-volume changes, this visual answers the question precisely and completely. Choice A (stacked area chart by raw count) shows the actual volume contributed by each channel over time. When monthly totals vary substantially, a channel's area can grow simply because total volume grew — not because its share increased. This conflates volume with proportion, which is exactly what management wants to ignore. Choice B (clustered column chart with raw counts) makes month-to-month comparisons within a channel reasonable, but comparing proportions across channels is visually awkward. Again, raw numbers obscure share when totals vary. Choice D (line chart with one line per channel plus a total line) adds noise by explicitly plotting the total-volume trend that management said is not part of the question. It also doesn't express each channel as a percentage, so share comparisons remain indirect. Study tip: On Power BI exam questions, watch for the phrase "percentage of total" or "share over time" — that's your signal to choose a 100% stacked visual. If the question instead emphasizes comparing absolute magnitudes, clustered or standard stacked charts become appropriate.

Question 4

A quality analyst has 200,000 transaction-duration values. The analyst needs to determine whether durations are symmetric or right-skewed and whether there are multiple concentration points. The report must use only standard Power BI visuals and must summarize the observations rather than display individual transactions.

Which approach should you use?

  1. Create duration bins and display their transaction counts in a column chart with a continuous order (correct answer)
  2. Display average duration by transaction date in a line chart with a continuous time axis
  3. Place transaction duration in a table and apply data bars to the duration value column
  4. Display duration categories in a pie chart after grouping transactions into equal-width bins
Explanation: When you need to analyze the shape of a distribution — symmetry, skewness, and clustering — you're essentially looking for a histogram. The key constraints here are: standard Power BI visuals only, no individual transaction rows displayed, and the ability to reveal distributional patterns across 200,000 values. Option A is the correct approach because creating duration bins and plotting their counts in a column chart with a continuous axis is a histogram in Power BI. Binning aggregates the 200,000 records into summary counts (no individual rows shown), and the continuous axis preserves the natural order of durations. A right-skewed distribution will show a long tail extending to the right, while multiple peaks (modes) reveal concentration points — exactly what the analyst needs. Option B fails because a line chart of average duration over time collapses the distribution into a single summary statistic per date. It tells you how the average changes over time, not whether the underlying distribution is skewed or multimodal. Option C is problematic because data bars on a table still display individual transaction rows, violating the requirement to summarize rather than show individual records. With 200,000 rows, this is also impractical and reveals nothing about distributional shape. Option D uses a pie chart, which shows proportional composition across categories — it cannot reveal order, tail behavior, or the asymmetry of a distribution. Pie charts are fundamentally the wrong tool for distributional analysis. Study tip: On Power BI exam questions about distribution shape, think "histogram" immediately. In Power BI, a histogram is built by binning a numeric field and using a column chart — recognize that pattern when the question mentions skewness, modality, or spread.

Question 5

A public-health report contains an age-adjusted disease rate for every state. Population and land area differ substantially among states. The report's analytical question is whether neighboring states form regional clusters of unusually high or low rates, not which state has the largest number of cases.

Which visual is most appropriate?

  1. A filled map that colors each state by the age-adjusted disease rate (correct answer)
  2. A bubble map that sizes one marker per state by the total number of cases
  3. A treemap that sizes each state by population and colors it by total case count
  4. A clustered bar chart that sorts states by the age-adjusted disease rate
Explanation: When choosing a map visual in Power BI, ask yourself two questions: What is the metric? and What spatial pattern am I trying to reveal? Here, the metric is an age-adjusted rate (already normalized, so population size is irrelevant), and the goal is to spot geographic clustering among neighboring states — a pattern that only emerges when states are shown in their actual positions with a consistent color encoding. A filled map (choropleth) is the right tool precisely because it colors each geographic region by a single continuous value — the age-adjusted rate — and preserves every state's real location. This lets your eye immediately detect whether high-rate states cluster together regionally, which is exactly the analytical question being asked. Choice B fails because bubble size encodes total case count, not the age-adjusted rate. Larger states with bigger populations will dominate the visual, distorting the comparison and obscuring the rate-based clustering the report cares about. Choice C compounds this problem: a treemap sizes regions by population and colors by raw case count, so both visual channels are driven by population rather than the normalized rate — it answers a completely different question. Choice D, a bar chart, does use the correct metric (age-adjusted rate) but destroys geographic context entirely. Sorting states alphabetically or by value tells you rankings, not whether neighboring states share similar rates. A useful rule of thumb: whenever a question emphasizes geographic proximity or clustering, a map visual is almost always the answer. And when a rate (not a count) is the metric, reach for a choropleth — bubble maps are for raw counts or totals.

Question 6

Operations managers need to investigate why late-delivery rates differ. They want to begin with the overall rate and interactively break it down by region, warehouse, carrier, product category, and shipping method. The order of investigation should be selectable during analysis rather than fixed by the report author.

Which visual should you choose?

  1. A key influencers visual configured only to rank dimensions associated with late deliveries
  2. A drill-down bar chart using a fixed region-to-warehouse-to-carrier hierarchy on the axis
  3. A matrix with every dimension nested in rows and late-delivery rate placed in values
  4. A decomposition tree with late-delivery rate as the analyzed measure and the dimensions as explanations (correct answer)
Explanation: When a question asks about interactive, user-driven exploration where the order of breakdown isn't predetermined, you're being tested on which visual supports ad hoc analytical navigation versus fixed, author-defined structures. The decomposition tree is purpose-built for exactly this scenario. It lets users start with an aggregate measure — here, the overall late-delivery rate — and then choose at runtime which dimension to expand next. Operations managers can decide in the moment whether to first split by region or carrier, then pivot their investigation based on what they see. This flexibility is the core feature that makes D the right answer. Option A is tempting but wrong. The key influencers visual ranks factors statistically associated with an outcome, but it doesn't let users freely sequence a multi-level breakdown — it's an analytical summary, not an interactive drill path. Option B fails because a drill-down hierarchy on a bar chart axis is fixed by the report author. The passage explicitly says the order must be "selectable during analysis," which a rigid region → warehouse → carrier hierarchy cannot support. Option C, a matrix with all dimensions nested in rows, is a static layout. Every combination is visible at once, making it overwhelming and unnavigable rather than interactively explorable. It also doesn't let users choose the order of breakdown. A useful pattern to remember: whenever a question mentions that users need to choose the order of dimensional analysis at runtime, that's the decomposition tree's signature use case. Drill hierarchies = fixed order; decomposition tree = user-selected order. Keeping that contrast sharp will help you eliminate distractors quickly on the exam.

Question 7

A financial report contains account groups, accounts, and cost centers in a hierarchy. Users must expand or collapse levels, review subtotals for each account group, and compare actual, budget, and variance values in adjacent columns. Precise value lookup is more important than identifying a visual trend.

Which visual should you use?

  1. A multi-row card with one card for each hierarchy member and each financial measure
  2. A clustered bar chart with hierarchy drill-down and three measures displayed for each category
  3. A stacked column chart with actual, budget, and variance treated as additive components
  4. A matrix with the hierarchy on rows and actual, budget, and variance as separate values (correct answer)
Explanation: When a question describes hierarchical data with expandable levels, subtotals, and multiple parallel numeric measures where precise lookup matters, you should immediately think "matrix visual." The matrix is Power BI's equivalent of a pivot table — it organizes rows into collapsible hierarchy levels, displays subtotals at each level automatically, and lets you place multiple measures as separate columns side by side. That combination maps perfectly onto the scenario: account groups → accounts → cost centers on rows, with Actual, Budget, and Variance as distinct columns for direct comparison. D is correct because the matrix handles every requirement stated: hierarchy expansion/collapse, subtotals per account group, and three measures in adjacent columns for precise value comparison. A is wrong because multi-row cards display individual values as separate card tiles. They don't support hierarchies, subtotals, or side-by-side columnar comparison — they're best for KPI spotlights, not structured financial tables. B is wrong because a clustered bar chart is built for visual comparison of magnitudes across categories, not precise value lookup. Drill-down in a bar chart replaces the parent level rather than expanding it in place, so you lose the parent-child context financial users need. Reading exact numbers from bars is also imprecise. C is wrong because a stacked column chart treats each measure as an additive segment of a whole. Actual, Budget, and Variance are not components that sum meaningfully (Variance is already derived from the other two), so stacking them distorts the data and obscures individual values. Your study tip: whenever a scenario emphasizes hierarchy navigation plus tabular precision plus multiple measures as columns, the matrix visual is almost always the answer in Power BI.

Question 8

A report must compare revenue for 30 product categories across the current year and prior year. The primary analytical question is which categories increased or decreased, and category names are too long to display clearly on a horizontal axis. Exact values are available on a separate detail page.

Which visual is most appropriate for the report?

  1. A stacked bar chart with current-year and prior-year revenue combined within each category
  2. A clustered bar chart with one bar for each year within every product category (correct answer)
  3. A matrix with product categories on rows and separate value columns for each year
  4. A ribbon chart that ranks categories independently within the current and prior years
Explanation: When comparing two measures (current year vs. prior year) across many categories with long names, your first instinct should be to think about two things: how to handle the long labels, and how to make the comparison clear without obscuring individual values. A clustered bar chart (B) is the right choice here because horizontal bars naturally accommodate long category names on the vertical axis, and clustering places two bars side-by-side for each category, making the year-over-year change visually immediate. With 30 categories, a reader can scan down the list and instantly spot which bars grew or shrank — exactly what the analytical question demands. Choice A, the stacked bar chart, combines both years into a single bar, which hides the comparison. You'd see total revenue per category, not the split between years, making it nearly impossible to judge whether revenue increased or decreased. Choice C, a matrix, does display both years clearly, but it's a table — it requires reading and comparing numbers rather than perceiving differences visually. The question explicitly notes exact values live on a separate detail page, signaling that this report should prioritize visual pattern recognition over precise figures. Choice D, a ribbon chart, is designed to show ranking changes over time across a continuous series, not a direct side-by-side magnitude comparison between two discrete periods. It would emphasize rank shifts, not revenue size differences. The study tip here: when a scenario mentions long labels and a need for visual comparison (not exact values), horizontal clustered bar charts are almost always the answer in Power BI. Watch for stacked charts as a common trap — stacking hides individual components.

Question 9

A finance report must explain how beginning operating profit becomes ending operating profit. The intermediate measures include revenue growth, price changes, labor costs, material costs, and one-time charges. Some measures increase profit and others decrease it.

Which visual should you use to show the contribution of each intermediate measure?

  1. A funnel chart ordered from the largest positive contribution to the largest negative contribution
  2. A waterfall chart with beginning and ending profit shown as totals and other measures as changes (correct answer)
  3. A stacked column chart with positive and negative contributions stacked into one ending-profit column
  4. A gauge chart with ending profit as the value and beginning profit as the target marker
Explanation: When a question asks you to visualize a bridge between two values — where intermediate steps either add to or subtract from a starting point — you should immediately think of the waterfall chart. This visual type is purpose-built for financial storytelling, especially variance and profit-bridge analyses. A waterfall chart displays a starting total, a series of incremental changes (positive or negative), and an ending total. In this scenario, beginning operating profit is your baseline, each intermediate measure (revenue growth, price changes, labor costs, etc.) floats above or below the previous bar as a change, and ending operating profit closes the visual as a final total. This makes it immediately clear how much each factor contributed — and in which direction — making B the correct choice. A is flawed because a funnel chart represents sequential stages of a process with declining volume (like a sales pipeline). Ordering contributions from largest to smallest doesn't communicate directionality or cumulative impact — it's the wrong tool entirely. C is tempting but misleading. A stacked column chart can show positive and negative values, but it doesn't naturally communicate a narrative flow from beginning to ending profit. Viewers would struggle to trace how each measure builds on the previous one, and the starting/ending distinction is lost. D is simply the wrong chart type. A gauge chart shows a single value against a target or range — it's useful for KPIs like "are we hitting our goal?" but it cannot display multiple contributing factors at all. Your study tip: whenever you see phrases like "bridge," "variance," or "beginning to ending," map that directly to the waterfall chart in Power BI.

Question 10

A report page must summarize monthly customer retention. Users need to see the latest retention rate, determine whether it is above or below a target, and understand whether retention has generally improved or declined over the preceding 12 months. Only one compact visual can be used.

Which visual best satisfies all three requirements?

  1. A card visual showing the latest retention rate with the target included in the visual title
  2. A gauge visual showing the latest retention rate against the target and configured maximum
  3. A KPI visual using retention as the indicator, month as the trend axis, and target as the goal (correct answer)
  4. A line chart showing monthly retention with a constant target line and no current-value label
Explanation: When a question asks which visual satisfies multiple simultaneous requirements — a current value, a target comparison, and a trend direction — your job is to match each requirement against what each visual type is actually designed to display. The KPI visual (answer C) is purpose-built for exactly this combination. It prominently displays the latest retention rate as the indicator value, compares it against a defined goal to show whether you're above or below target (typically with color coding), and uses the trend axis — here, month — to render a small sparkline showing directional movement over the preceding 12 months. One compact visual, three requirements satisfied simultaneously. Answer A fails because a card visual displays only a single static value. Embedding the target in the title is a workaround, not a functional comparison, and there is no trend visualization at all. Answer B, the gauge, shows the current value against a target and a configured maximum, but it provides no trend information — you cannot see whether retention has improved or declined over time. That eliminates it for this scenario. Answer D, the line chart, handles trend well and can show a target line, but it does not surface the current retention value as a prominent, readable KPI, and line charts are generally not considered "compact" for dashboard summaries. The key study tip: memorize the three-part anatomy of a KPI visual — indicator (current value), goal (target), and trend axis (sparkline). Any exam question that asks for all three in a single compact visual is pointing you directly to KPI. If only two of the three are needed, a gauge or card may suffice.