Power BI Data Analyst · 25% of the exam

Visualize and analyze the data: free practice questions

5 sample questions from our 63-question bank for this domain — answers and explanations included. These are the same scenario-based style as the real Microsoft exam.

1. A Power BI developer is working on a sales report. She has a bar chart showing revenue by salesperson. She wants to configure a tooltip so that when a user hovers over a bar, a separate, richly formatted report page appears showing that salesperson's monthly trend, top products, and quota attainment. What must she do to implement this?

  • A. Add all additional fields directly to the Tooltips field well of the bar chart
  • B. Create a dedicated report page, set its page type to 'Tooltip' in the page settings, and reference it in the bar chart's tooltip settings✓ Correct
  • C. Enable the 'Canvas tooltip' option in the bar chart's format settings and drag additional visuals onto the tooltip layer
  • D. Create a drillthrough page for the salesperson and enable the 'Show as tooltip' toggle on that page
Explanation

Report page tooltips are created by making a dedicated report page and setting its page type to 'Tooltip' in the page size/type settings. The bar chart is then configured to use that specific page as its tooltip, allowing a rich, multi-visual tooltip to appear on hover. Simply adding fields to the Tooltips field well produces a default tabular tooltip, not a custom report page tooltip. There is no 'Canvas tooltip' option that allows dragging visuals onto a tooltip layer. A drillthrough page requires a right-click action and navigation; enabling 'Show as tooltip' is a feature for drillthrough pages to also serve as tooltips, but the primary method for a richly designed tooltip is the dedicated tooltip page approach.

2. A Power BI developer is building a report for a retail chain. She adds a slicer for 'Store Region' and wants to prevent report consumers from clearing the slicer selection entirely — at least one region must always be selected. Which slicer setting should she configure?

  • A. Enable the 'Single select' toggle in the slicer's Format pane
  • B. Turn off the 'Show "Select all" option' toggle in the slicer settings
  • C. Enable 'Require single selection' under the slicer's Selection controls✓ Correct
  • D. Set a visual-level filter on the slicer to exclude blank values
Explanation

The 'Require single selection' option under Selection controls forces users to always have exactly one item selected, preventing the slicer from being cleared. 'Single select' just prevents multi-selection but still allows clearing. Hiding 'Select all' removes the all-items option but does not prevent the user from deselecting every individual item. A visual-level filter on blank values controls what items appear in the slicer, not whether a selection is mandatory.

3. A Power BI developer is building a report for a retail company. She wants to add a visual that allows users to type natural language questions like 'total sales by region last quarter' and receive instant visual answers. Which visual type should she add to the report canvas in Power BI Desktop?

  • A. Smart Narrative visual
  • B. Q&A visual✓ Correct
  • C. Key Influencers visual
  • D. Decomposition Tree visual
Explanation

The Q&A visual allows users to type natural language questions and receive dynamically generated visual answers based on the data model. Smart Narrative generates automated text summaries but does not accept user-typed questions. Key Influencers analyzes factors that drive a specific metric but does not support free-text queries. Decomposition Tree is used to drill into hierarchical breakdowns of a measure but is not a natural-language query interface.

4. A report author wants to let executive stakeholders quickly switch between viewing 'Revenue', 'Profit', and 'Units Sold' on the same bar chart without using slicers that filter the data. The measures already exist in the model. Which technique achieves this most efficiently?

  • A. Create three separate bar chart visuals and use bookmarks to show/hide them
  • B. Add all three measures to the Values field well of one bar chart so they appear as grouped bars
  • C. Use a Field parameter to create a dynamic measure selector that drives the chart's Values field✓ Correct
  • D. Use a What-if parameter table and bind it to the chart's visual-level filter
Explanation

A Field parameter (introduced in Power BI) creates a parameter table that allows users to select which measure (or field) to display in a visual, dynamically changing what is plotted. This is the most efficient, purpose-built approach. Using bookmarks with three hidden visuals works but is cumbersome to maintain and scales poorly. Adding all three measures as grouped bars displays all values simultaneously rather than switching between them. A What-if parameter is for numeric value inputs (e.g., scenarios), not for selecting between existing model measures.

5. A senior Power BI developer is building a complex sales report. She wants to use the Decomposition Tree visual to let users analyze total sales and manually choose which dimension to expand at each level. Which Decomposition Tree feature supports this behavior?

  • A. Setting all fields to 'High value' AI splits so the tree always expands the highest-contributing dimension
  • B. Adding dimensions to the 'Explain by' field well and leaving the split type as 'Choose' so users select the next dimension✓ Correct
  • C. Placing dimensions in the 'Axis' field well and enabling the 'User-driven drill' toggle in Format pane
  • D. Using the 'Low value' AI split option, which automatically identifies the dimension the user is most likely to explore next
Explanation

In the Decomposition Tree, fields added to the 'Explain by' well can be set to expand using AI splits (High value / Low value) or left as user-chosen splits. When the split type is 'Choose' (manual), a '+' button appears at each node and users select which dimension to expand next — supporting interactive, user-directed exploration. 'High value' AI splits automatically pick the best dimension, removing user choice. There is no 'Axis' field well or 'User-driven drill' toggle in the Decomposition Tree — that language comes from other visuals. 'Low value' AI splits automatically highlight the smallest contributors, also removing user choice.

58 more questions in this domain

Practice the full bank with instant grading, flashcards, and a timed mock exam.

Start practicing free