BenchMark Quizzes by MDFT Pro

Configure Drillthrough To Detail Page In Power BI

You are working on a Power BI report at MDFT Pro. The main page, named Sales, shows total sales by city. You need to configure a drillthrough interaction to a detail page that displays sales by city and product line, while preserving all filters from the main page.

Which actions should you perform to enable this drillthrough functionality? Select all that apply.

Choose all correct answers from the options below.

Explanations for each answer:

Create a new page named Detail. is correct. A detail page is needed for drillthrough interactions.
Create a table visual to show total sales by city and product line. is correct. The detail page should display sales by city and product line.
On the Detail page, under the Drillthrough option, add City column as the drill through field. is correct. Adding City as the drillthrough field enables redirection from the main page.
On the Detail page, under the Drillthrough option, set Keep all filters to On. is correct. This ensures all filters from the main page are preserved on the detail page.

Learn more about drillthrough in Power BI:

Power BI Drillthrough

Exam Preparation Quiz

Configure Drillthrough To Detail Page In Power BI