"Filled Map" - problem with a Legend and Location

[rodneyrick]

Hello,

I'm trying to create a visualization using the "Filled Map" view by filling in the location information with Country, State and City, and the Legend field with the information I would like to color each of the regions of interest.

However, when representing such information, some locations remain empty or are being represented elsewhere on the map, maintaining their proper color but being represented within a different region. And even using Latitude and Longitude information, the problem remains.

I have already reviewed the information of municipalities names, checking that the names are spelled correctly, and everything is ok.

Has anyone had this?

[v-xicai]

Hi @rodneyrick ,

Map data can be ambiguous. For example, there's a Paris, France, but there's also a Paris, Texas. Your geographic data is probably stored in separate columns – a column for city names, a column for state or province names, etc. – so Bing may not be able to tell which Paris is which. If your dataset already contains latitude and longitude data, Power BI has special fields to help make the map data unambiguous. Just drag the field that contains your latitude data into the Visualizations > Latitude area. And do the same for your longitude data.

For reference:

Create and use filled maps (choropleth maps) in Power BI

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rodneyrick]

I tried to use the choropleth maps but did not work. It is need to use a JSON to identify the polygon or need the entire map of Brazil, which is also not an option.