Forum Discussion
Shape Map Not Works in Desktop but not Online
- 9 years ago
We have our Location field in the map using a field that combines CITY, STATE COUNTRY.
These maps ceased to work with the June release.We were able to correct this by selecting our CITY, STATE COUNTRY field, and then in the Modeling tab changing the Data Category to PLACE.
This is the only method we have had success with the new (as of June release) maps. The MS documentation showing Country & postal code hierarchy has not worked for us. It confuses citys with Countries and vice versa at least a third of the time.
Hello,
I have managed to understand the issue now.
I was working with data which originally stated (London, UK) which worked fine. The reason I added UK to the end was to dinstinguish between JERSEY,UK and JERSEY USA etc. However with the recent change Power BI is trying to create a heirarchy and hence wont be able to plot data with what it sees as two variables.
They have informed me to do the following.
Hi Simon Davies,
Please find the below resolution for issue,
Most likely this customer will have to change their report slightly now. I’m guessing they were using string-concatentation to combine country and zip code or similar. Now they need to create a hierarchy by dragging both Country and Zip fields into the Location bucket and Drill Down via Hierarchy (fork icon) to query with country and zip.
Let me know if this resolves your issue.
Thanks All
Simon
We have our Location field in the map using a field that combines CITY, STATE COUNTRY.
These maps ceased to work with the June release.
We were able to correct this by selecting our CITY, STATE COUNTRY field, and then in the Modeling tab changing the Data Category to PLACE.
This is the only method we have had success with the new (as of June release) maps. The MS documentation showing Country & postal code hierarchy has not worked for us. It confuses citys with Countries and vice versa at least a third of the time.
- mtstewart179 years ago
Advocate I
I had the exact same thing with City, State, Country and this solution worked for me. It sounds like changing the Data Category field can help Bing maps plot the point correctly.