Crucial Exams

Microsoft Power BI Data Analyst Practice Question

You build a Power BI report that contains a summary page and a detailed "Order Details" page. On the summary page, users can select a calendar year in a slicer and then right-click a bar in a Sales by Region chart to open the "Order Details" page through drill-through. The drill-through correctly filters by the selected region, but the Year slicer selection is lost and the detailed page shows data for all years. You need to make sure the Year filter is preserved whenever users drill through.

Which action should you perform on the "Order Details" page?

  • Add the Year field to the tooltip of the Sales by Region visual.

  • Enable Sync slicers for the Year slicer between the two pages.

  • Turn on the Keep all filters toggle in the page's Drill-through settings.

  • Enable Cross-report drill-through for the report in Power BI Desktop.

Microsoft Power BI Data Analyst
Visualize and Analyze the Data
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot