Crucial Exams

Microsoft Power BI Data Analyst Practice Question

A Power BI data analyst is creating a sales report with a clustered column chart showing revenue by product category. To provide deeper, contextual insights, the analyst wants a custom pop-up to appear when a user hovers over a category's column. This pop-up should contain other visuals, such as a table with the top 5 products and a card displaying the total units sold for that specific category. Which set of steps must the analyst perform to enable this functionality?

  • Drag the 'Product' and 'Units Sold' fields into the 'Tooltips' field well of the original chart. Then, in the 'Format' pane, change the tooltip 'Type' to 'Default' to show these additional fields.

  • Create a new drillthrough page containing the detailed visuals. Add the 'Product Category' field to the 'Drillthrough' filter well on the new page. Users can then right-click the chart to navigate.

  • Create a new report page and add the desired visuals. In the new page's 'Format' pane, enable 'Allow use as tooltip'. Then, for the original chart, set the 'Tooltip Type' to 'Report page' and select the new page.

  • Create a bookmark for the detailed view. On the original chart, configure an 'Action' in the 'Format' pane to navigate to the bookmark when a data point is selected.

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