PrepAway - Latest Free Exam Questions & Answers

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

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.

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


Leave a Reply