Crucial Exams

Microsoft Power BI Data Analyst Practice Question

You are building a Power BI report with two visuals on the same page: a pie chart showing sales by country and a column chart showing sales by city. When a user selects a country in the pie chart, the column chart currently highlights the sales for the cities in that country, while dimming the columns for cities in other countries. The requirement is to change this so that selecting a country in the pie chart filters the column chart to show only the columns for the cities in the selected country. How should you achieve this?

  • Select both the pie chart and the column chart, right-click, and select 'Group'.

  • Open the 'Sync slicers' pane and create a new group that includes both the pie chart and the column chart.

  • With the column chart selected, use the 'Filters' pane to add an advanced filter based on the selection in the pie chart.

  • Select the pie chart, navigate to the 'Format' menu, select 'Edit interactions', and then select the 'Filter' icon on the column chart.

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