Microsoft Power BI Power BI Visualizations and Report Design 2 — Questions and Answers
Question 1: What is 'Conditional Formatting' in Power BI visuals?
- Formatting that only applies on mobile layouts
- Dynamic formatting of visual elements (colors, icons, data bars) based on data values or measures (Correct answer)
- A formatting template that applies to all visuals at once
- Auto-formatting applied when a measure exceeds a threshold
Correct answer: Dynamic formatting of visual elements (colors, icons, data bars) based on data values or measures
Conditional Formatting dynamically changes the color, icon, or data bar of a visual's elements based on field values or measure results, highlighting important data points.
Question 2: What is a 'Decomposition Tree' visual used for in Power BI?
- Showing a file system directory structure
- Enabling users to interactively break down a metric across multiple dimensions in an exploratory, tree-like layout (Correct answer)
- Displaying a decision tree from a machine learning model
- Decomposing time series data into trend and seasonality
Correct answer: Enabling users to interactively break down a metric across multiple dimensions in an exploratory, tree-like layout
The Decomposition Tree visual lets users interactively drill into a measure by adding dimensions one at a time, revealing which categories contribute most to the metric.
Question 3: What does 'Bookmarks' feature in Power BI allow report designers to do?
- Save the current report page as a PDF bookmark
- Capture a specific state of a report (filters, slicer selections, visibility) and replay it with a click (Correct answer)
- Bookmark external URLs for reference within the report
- Save a report version for version control
Correct answer: Capture a specific state of a report (filters, slicer selections, visibility) and replay it with a click
Bookmarks save the current state of the report including all filter selections, slicer values, and visual visibility settings, and can be triggered via bookmark buttons for guided storytelling.
Question 4: What is the 'Key Influencers' visual in Power BI used for?
- Showing KPI metrics for sales influencers
- Analyzing and explaining which factors (fields) statistically drive a specific metric up or down (Correct answer)
- Displaying social media influencer data
- A visual that ranks the top contributors by sales value
Correct answer: Analyzing and explaining which factors (fields) statistically drive a specific metric up or down
The Key Influencers visual uses machine learning to analyze your data and explain which fields have the most statistical influence on a selected metric.
Question 5: What does 'Small Multiples' in Power BI allow you to create?
- Multiple copies of a report for different users
- A grid of the same chart repeated for each value in a selected dimension, enabling easy comparison (Correct answer)
- Multiple measures displayed as KPI cards in a row
- Multiple datasets refreshed in parallel
Correct answer: A grid of the same chart repeated for each value in a selected dimension, enabling easy comparison
Small Multiples (also called trellis or panel charts) create a grid of the same visual type, each showing a different segment, making it easy to compare trends across categories.
Question 6: What is the 'Selection Pane' in Power BI Desktop used for?
- Selecting data from external databases
- Managing the visibility, order, and names of all visual objects on a report page (Correct answer)
- Selecting color themes for the report
- Managing row-level security selections
Correct answer: Managing the visibility, order, and names of all visual objects on a report page
The Selection Pane lists all objects on a report page and lets you control their visibility (show/hide), layer order (z-order), and names, which is essential for bookmark-based interactivity.
Microsoft Power BI Power BI Visualizations and Report Design 2
What is 'Conditional Formatting' in Power BI visuals?