Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataHard
A data analyst is designing a Power BI report that includes multiple pages, each focusing on a different aspect of sales data (e.g., Sales by Product, Sales by Region, Sales Trends). The analyst wants to create a navigation experience where users can easily jump between these detailed pages from a high-level summary page, filtering the target page based on a selection made on the summary page. Which feature should the analyst implement for this enhanced navigation?
- ASlicers
- BDrill-through
- CPage Tooltips
- DBookmarks
Show answer & explanationAnswer & explanation
Correct answer: B. Drill-through
Drill-through allows users to navigate from a summary page to a more detailed page, passing the context (filters) of their selection. This means if a user selects a specific product on the summary page, drilling through to the 'Sales by Product' page will automatically filter that page to show data for only the selected product.
Why the other options are wrong
- A. Slicers are used to filter data *within* a page or across pages if synced, but they don't provide a direct navigation mechanism based on a specific selection from a visual to a new, filtered page.
- C. Page tooltips provide additional information on hover but do not facilitate navigation or filtering of target pages.
- D. Bookmarks save the current state of a report page (filters, visuals, etc.) but don't inherently pass filter context from a selection on one page to another upon navigation.
Power BI Drill-through
A Power BI feature that enables users to navigate from a data point in one report page (source) to another report page (destination), with the destination page automatically filtered by the context of the selected data point.
- Passes filter context from source to destination page.
- Used for detailed analysis on a specific item.
- Requires defining drill-through fields on the destination page.
Memory trick: Navigate through details, drill deep down, contextually filtered, without a frown.