Microsoft Power BI Power BI Visualizations and Report Design 1 — Questions and Answers
Question 1: What is the purpose of a 'Slicer' visual in Power BI?
- To display trend data over time
- To provide an on-canvas filter that users can interact with to filter other visuals on the page (Correct answer)
- To slice a dataset into smaller datasets
- To partition report pages
Correct answer: To provide an on-canvas filter that users can interact with to filter other visuals on the page
A Slicer is an interactive filter visual placed on the report canvas that allows users to click or select values to filter all other visuals on the page.
Question 2: What does the 'Drill Through' feature in Power BI reports allow?
- Drilling into the underlying SQL query of a visual
- Navigating from a summary visual to a detailed report page filtered to the selected data point (Correct answer)
- Expanding a hierarchy within a single visual
- Drilling down into nested DAX calculations
Correct answer: Navigating from a summary visual to a detailed report page filtered to the selected data point
Drill Through lets users right-click a data point in a visual and navigate to a dedicated detail page that is automatically filtered to that specific context.
Question 3: What is a 'Waterfall chart' best used for in Power BI?
- Showing cumulative totals over time
- Visualizing how positive and negative values contribute to a running total (Correct answer)
- Displaying hierarchical data as nested rectangles
- Comparing parts of a whole across categories
Correct answer: Visualizing how positive and negative values contribute to a running total
A Waterfall chart shows how a starting value is affected by a series of positive and negative incremental values to arrive at a final value.
Question 4: What does the 'Sync Slicers' feature in Power BI allow?
- Synchronizes the slicer with an external calendar
- Allows a slicer to control multiple report pages simultaneously (Correct answer)
- Syncs slicer selections across users in real time
- Links two slicers to the same data field
Correct answer: Allows a slicer to control multiple report pages simultaneously
Sync Slicers lets you configure a slicer on one report page to also filter (and optionally appear on) other pages, keeping selections consistent across the report.
Question 5: What is a 'Treemap' chart in Power BI best suited for?
- Showing relationships between nodes in a network
- Displaying hierarchical data as nested, proportionally sized rectangles (Correct answer)
- Tracking changes in rankings over time
- Comparing two categories side by side
Correct answer: Displaying hierarchical data as nested, proportionally sized rectangles
A Treemap displays hierarchical data as nested rectangles where the size of each rectangle is proportional to its value, making it easy to see relative proportions within categories.
Question 6: What is the 'Page Navigation' button type in Power BI reports used for?
- Linking to external websites
- Creating a clickable button that navigates the user to another page within the same report (Correct answer)
- Navigating between Power BI workspaces
- Jumping to a specific visual on the current page
Correct answer: Creating a clickable button that navigates the user to another page within the same report
Page Navigation buttons allow report designers to create custom navigation experiences, routing users to specific pages with a click, replacing the default page tabs.
Microsoft Power BI Power BI Visualizations and Report Design 1
What is the purpose of a 'Slicer' visual in Power BI?