Exam 70-778 topic 1 question 28 discussion

Actual exam question from Microsoft's 70-778

Question #: 28
Topic #: 1

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?

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.

Show Suggested Answer

Suggested Answer: D 🗳️
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

by Harsha at Dec. 28, 2019, 12:22 p.m.