Geography Layers

Hi microsoftrookie,

You get an expected behavior in filled map. As your post, we are only able to select the geography column as either a state or a country. When you label geography column as country, how does Power BI recognize New Jersey as a country since it is a state? And vice versa.

In your scenario, if you persist to use filled map, you would need to separate data of  New Jersey and United States into different tables, then create two filled maps.

However, if you don’t want to separate data of  New Jersey and United States into different tables, then you can add Latitude and Longitude columns in your current table, and create a map visual instead of filled map using Latitude, Longitude columns and numerical data columns. This way, when you create a slicer using geography column, you can highlight proper section in map visual when selecting value in the slicer.

Thanks,
Lydia Zhang