Question 232 of 388
Single answerYou 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:- Customer ID- CustomerName- Address- City- ProvState- CountryYou 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?
AIn the Value field, add Country. In the Legend field, add ProvState at the top, followed by City.
BIn the Legend field, add Country. In the Axis field, add ProvState at the top, followed by City.
✓CIn the Axis field, add Country at the top, followed by ProvState, and then City.
DIn the Value field, add Country at the top, followed by ProvState, and then City.
✓
Correct Answer: C
In the Axis field, add Country at the top, followed by ProvState, and then City.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.