Exam 70-778 topic 1 question 29 discussion

Actual exam question from Microsoft's 70-778

Question #: 29
Topic #: 1

You have a table named Sales that contains sales data for the United States. A sample of the data in Sales is shown in the following table.

When you attempt to create a map that shows SalesAmount by Zone, you discover that the map shows a bubble based on cities instead of states.
You need to ensure that the map shows bubbles based on states.
What should you do?

A. Add a column named Country that contains United States as the value.
B. Add a column for longitude and a column for latitude.
C. Select the Zone field. From the Modeling tab, change the Data Category.
D. Select the Zone field. From the Modeling tab, change the Data Type.

Show Suggested Answer

Suggested Answer: C 🗳️
References:
https://docs.microsoft.com/en-us/power-bi/guided-learning/visualizations#step-5

by kilowd at Feb. 20, 2020, 3:28 p.m.

Comments

Submit Cancel

kilowd

Highly Voted 5 years, 3 months ago

This is a common problem when the data in your location field is ambiguous, such as using an area name like Washington, which could indicate a state or a district. One way to resolve the location data problem is to rename your column to be more specific, such as State. Another way is to manually reset the data category by selecting Data Category on the Modeling tab. From the Data Category list, you can assign a category to your data such as "State" or "City."

upvoted 16 times

...