Power BI 778 Visualizations and Report Design 2 — Questions and Answers
Question 1: What is cross-filtering in Power BI reports?
- Filtering data in Power Query
- When selecting a data point in one visual automatically filters other visuals on the same page (Correct answer)
- Applying the same filter to multiple report pages
- Filtering across multiple data sources
Correct answer: When selecting a data point in one visual automatically filters other visuals on the same page
Cross-filtering occurs when clicking a data point in one visual filters the data displayed in other connected visuals on the report page.
Question 2: What is the purpose of a waterfall chart in Power BI?
- Showing correlation between two variables
- Displaying cumulative effects of sequential positive and negative values (Correct answer)
- Comparing categories side by side
- Mapping geographic data
Correct answer: Displaying cumulative effects of sequential positive and negative values
A waterfall chart shows how a series of positive and negative values cumulatively contribute to a final total.
Question 3: What is a report tooltip in Power BI?
- A text box that appears on the report canvas permanently
- A hover-over display that shows additional information about a data point (Correct answer)
- A filter applied only to a specific visual
- A legend that appears at the bottom of a visual
Correct answer: A hover-over display that shows additional information about a data point
A report tooltip is a custom or default popup that appears when a user hovers over a visual, showing additional data context.
Question 4: What is the function of 'Bookmarks' in Power BI?
- Saving favorite data sources
- Capturing the current state of a report page for navigation or storytelling (Correct answer)
- Pinning visuals to a dashboard
- Scheduling report refresh
Correct answer: Capturing the current state of a report page for navigation or storytelling
Bookmarks save the current state of a report page (filters, slicers, visibility) and can be used for navigation or storytelling.
Question 5: Which Power BI feature allows you to show different visuals based on a user's selection using buttons?
- Drill-through
- Bookmarks with buttons (Correct answer)
- Page navigation
- Conditional formatting
Correct answer: Bookmarks with buttons
Combining bookmarks with buttons allows you to create toggle effects that show and hide different visuals based on user interaction.
Question 6: What does 'Conditional Formatting' in Power BI allow you to do?
- Apply filters based on conditions in the data model
- Change visual colors, icons, or background based on data values or measures (Correct answer)
- Format the M code in Power Query
- Create conditional DAX expressions
Correct answer: Change visual colors, icons, or background based on data values or measures
Conditional formatting lets you dynamically apply colors, data bars, icons, or web URLs to table and matrix cells based on their values.
Power BI 778 Visualizations and Report Design 2
What is cross-filtering in Power BI reports?