Microsoft Certified Data Analyst Associate Data Visualization and Reports in Power BI 1 — Questions and Answers
Question 1: Which Power BI visual type is best suited for displaying trends over a continuous time period?
- Pie chart
- Line chart (Correct answer)
- Treemap
- Funnel chart
Correct answer: Line chart
Line charts connect data points sequentially over time, making trends immediately visible to the viewer.
Question 2: What is the primary purpose of slicers in Power BI reports?
- To create calculated columns in the data model
- To filter data visually on a report page (Correct answer)
- To merge multiple tables together
- To schedule automatic data refresh
Correct answer: To filter data visually on a report page
Slicers provide an on-canvas filter control that allows report viewers to interactively filter visuals on the page.
Question 3: In Power BI, what does 'cross-filtering' between visuals mean?
- Filtering data from external sources into the report
- Applying filters from one page to all other report pages
- Selecting data in one visual automatically filters other visuals on the same page (Correct answer)
- Creating filter expressions in DAX that span multiple tables
Correct answer: Selecting data in one visual automatically filters other visuals on the same page
Cross-filtering means that selecting a data point in one visual automatically filters the data shown in other visuals on the same report page.
Question 4: Which Power BI visual is most appropriate for displaying a single aggregated key metric prominently?
- Matrix visual
- Scatter chart
- Card visual (Correct answer)
- Waterfall chart
Correct answer: Card visual
The Card visual is specifically designed to display a single aggregated metric in large format on a report page.
Question 5: What is a KPI visual used for in Power BI?
- Comparing multiple dimensions side by side
- Showing geographic distribution of data across a map
- Displaying hierarchical relationships between categories
- Tracking a key metric's performance against a defined target value (Correct answer)
Correct answer: Tracking a key metric's performance against a defined target value
KPI visuals display a key metric alongside a target value and show progress toward that goal with directional indicators.
Question 6: In Power BI Desktop, which ribbon option allows you to configure how visuals interact with each other on a report page?
- View ribbon > Page view
- Modeling ribbon > New parameter
- Format ribbon > Edit interactions (Correct answer)
- File > Options and settings
Correct answer: Format ribbon > Edit interactions
The 'Edit interactions' option in the Format ribbon lets you control whether one visual filters, highlights, or has no effect on other visuals.
Question 7: Which Power BI chart type displays hierarchical data as nested rectangles where each rectangle's size represents its proportional value?
- Donut chart
- Gauge chart
- Funnel chart
- Treemap (Correct answer)
Correct answer: Treemap
Treemaps display hierarchical data as nested rectangles where each rectangle's size is proportional to its underlying value.
Microsoft Certified Data Analyst Associate Data Visualization and Reports in Power BI 1
Which Power BI visual type is best suited for displaying trends over a continuous time period?