How should you configure the drill down in the bar chart?

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:

• Customer ID

• 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?
A . In the Value field, add Country. In the Legend field, add ProvState at the top, followed by City.
B. In the Legend field, add Country. In the Axis field, add ProvState at the top, followed by City.
C. In the Axis field, add Country at the top, followed by ProvState, and then City.
D. In the Value field, add Country at the top, followed by ProvState, and then City.

View Answer

Answer: C

Explanation:

References:

https://docs.microsoft.com/en-us/power-bi/guided-learning/visualizations#step-18

https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-drill-down