Power BI 778 Visualizations and Report Design 1 — Questions and Answers
Question 1: Which Power BI visual type is best suited for showing trends over time?
- Pie chart
- Line chart (Correct answer)
- Treemap
- Funnel chart
Correct answer: Line chart
Line charts display data points connected across a continuous axis, making them ideal for showing trends or changes over time.
Question 2: What does a slicer do in Power BI?
- Removes rows from the data model
- Provides an on-canvas filter that lets report users interactively filter visuals (Correct answer)
- Creates a new calculated column
- Splits a visual into multiple panels
Correct answer: Provides an on-canvas filter that lets report users interactively filter visuals
A slicer is a visual filter element that report users can interact with to filter all connected visuals on the page.
Question 3: Which visual is most appropriate for displaying part-to-whole relationships as percentages?
- Bar chart
- Scatter chart
- Pie or donut chart (Correct answer)
- Waterfall chart
Correct answer: Pie or donut chart
Pie and donut charts show how individual parts contribute to a total whole, making them ideal for percentage breakdowns.
Question 4: What is a KPI visual in Power BI used for?
- Displaying geographic data on a map
- Showing a metric against a target or goal with a status indicator (Correct answer)
- Comparing multiple measures side by side
- Filtering report pages
Correct answer: Showing a metric against a target or goal with a status indicator
A KPI visual displays a key metric compared to a defined target, with a trend indicator showing progress direction.
Question 5: What does the 'Drill Down' feature in Power BI visuals allow users to do?
- Export data to Excel
- Navigate from a higher level of a hierarchy to a more detailed level (Correct answer)
- Filter the entire report page
- Change the visual type
Correct answer: Navigate from a higher level of a hierarchy to a more detailed level
Drill Down lets users click into a visual to explore deeper levels of a data hierarchy, such as going from Year to Quarter to Month.
Question 6: Which Power BI visual allows you to display geographic data on an interactive map?
- Treemap
- Shape map
- Filled map or Map visual (Correct answer)
- Funnel chart
Correct answer: Filled map or Map visual
The Map and Filled Map visuals in Power BI plot data geographically using location fields like country, state, or latitude/longitude.
Power BI 778 Visualizations and Report Design 1
Which Power BI visual type is best suited for showing trends over time?