Forum Discussion
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
Hi microsoftrookie,
Could you please share sample data of your scenario and post expected result here? We also need to know that what fields you use to create the filled map visual.
Besides, please take a look at the following blog about creating filled map in Power BI Desktop.
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tutorial-filled-maps-choropleths/
Thanks,
Lydia Zhang
Sure thing.
I do not know if I did this correctly, however I need to be able to display both United States and New Jersey as their own seperate entities. The first picture is a sample of some numerical data that we used for the nation, and the nation data is in the same column as a state's data. The next picture is how the geographies are listed in the same column in the queries. For example, pie charts and graphs are able to both of these geographies numerical data well. I need to be able to represent the nation as highlighted in the third picture, but when a slicer is selected like in the 5th picture, I need it to highlight just the state as it is in the 4th picture. However, currently I can only select my geography column as either a state or a country, and will only pick up on highlighting one and returning the final map, as shown with nothing filled in. So, if the column is labeled at country, and I select a New Jersey slicer will not highlight new jersey, but if I select United States it has been returning the filled Country map like in picture 3, and vice versa.
Sure thing.
I do not know if I did this correctly, however I need to be able to display both United States and New Jersey as their own seperate entities. The first picture is a sample of some numerical data that we used for the nation, and the nation data is in the same column as a state's data. The next picture is how the geographies are listed in the same column in the queries. For example, pie charts and graphs are able to both of these geographies numerical data well. I need to be able to represent the nation as highlighted in the third picture, but when a slicer is selected like in the 5th picture, I need it to highlight just the state as it is in the 4th picture. However, currently I can only select my geography column as either a state or a country, and will only pick up on highlighting one and returning the final map, as shown with nothing filled in. So, if the column is labeled at country, and I select a New Jersey slicer will not highlight new jersey, but if I select United States it has been returning the filled Country map like in picture 3, and vice versa.
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 ZhangThank you very much. Simply when i select new jersey, it does not recogognize it at all as a location on the map, and if they are labeled as a state geographies the united states is not recognized. However, Thank you for longitude and latitude suggestion.
