Crucial Exams

Microsoft Power BI Data Analyst Practice Question

You are developing a Power BI report with two pages: "Sales Overview" and "Category Details". The "Sales Overview" page has a bar chart showing sales by [Product Category] and a slicer for [Year]. The "Category Details" page is designed to show detailed metrics for a single product category.

You need to enable users to right-click a category on the "Sales Overview" bar chart and navigate to the "Category Details" page. The "Category Details" page must be filtered by the selected [Product Category] but must not be affected by the [Year] slicer on the "Sales Overview" page.

Which set of actions will accomplish this?

  • On the "Category Details" page, add the [Product Category] field to the drillthrough well in the Visualizations pane. Then, enable the "Keep all filters" option.

  • On the "Sales Overview" page, configure the "Edit interactions" settings for the bar chart to filter a table on the "Category Details" page.

  • Create a bookmark on the "Category Details" page. On the "Sales Overview" page, select the bar chart and assign the bookmark as a "Drill through" action in the Format pane.

  • On the "Category Details" page, add the [Product Category] field to the drillthrough well in the Visualizations pane. Then, disable the "Keep all filters" option.

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