Analyzing and Visualizing Data with Microsoft Power BI — Question 96

You plan to develop a Power BI report that has a bar chart to display the number of customers by location.
You have a table named Customer that has the following columns:
✑ CustomerID
✑ CustomerName
✑ Address
✑ City
✑ ProvState
✑ Country
You need to allow users to drill down by location. The report will display the number of each customer by Country, and drill down to ProvState, and then to City.
How should you configure the drill down in the bar chart?

Answer options

• A. In the Legend field, add Country. In the Axis field, add ProvState at the top, followed by City.
• B. In the Value field, add Country at the top, followed by ProvState, and then City.
• C. In the Value field, add Country. In the Legend field, add ProvState at the top, followed by City.
• D. In the Axis field, add Country at the top, followed by ProvState, and then City.

Correct answer: D

Explanation

The correct answer is D because the Axis field needs to be organized in a hierarchy for drill down functionality, starting with the highest level, Country, followed by ProvState, and then City. Options A and C incorrectly place locations in the Legend field, which does not support drill down. Option B misplaces the fields in the Value area, which is not suitable for drill down configuration.