Forum Discussion
Mapping and limitations
Dear all,
I have couple of questions related Mapping capability in power bi. My data hierarchy is something like this
Level 1: Area ==> Filled map to represent the bountry of various areas
Level 2: Church ==> once I click on specific are Churches to be marked as bubble map
Level 3: Pioneer ==> once I select church, pioners under church need to be marked again as bubble
Level 4: Fellowship ==> Once I select pioneer, Fellowship under that needs to be marked
All these entities are having address in the following format.
| Entity name | Address | City | State | Zip code | Country | Latitude | Logitude |
| Area name/ Church name/ Pioneer name/ Fellowship name | 0/1, 2nd Cross, Ulsoor Road, Ulsoor | Bangaluru | Karnataka | 560042 | India | 6.1361 | 80.254868 |
- Can I have combination of filled chart and bobble chart. so that I can mark Area as Filled and rest all bubble. As per my knowledge this is not possible.
- Filled Map: I tried filled map. It marks 3 entities 4th one it did not. Above all it behave very strange. when I drill down to second level the auto focus takes Avg. Lat/Long and makes whole screen filled with next level entity.
- I have all the data for the country "Srilanka". For Choropleth I am not sure where to find the Json.
- I tried even with custom Shape Map. there is no drill down feature here.
- My question to you all can I drill down to 4th level in any one of the map.
I have been seeing maps maps from past 15 days. Please let me know which map could probaly suite my requirement.
Trust I am not trobling you too much :-) Please let me know if you need the data to understand.
Thanks,
Prasanna V.
I'm not sure whether it is possible or not, but it kind of goes against the idea of filled map. It's not suppose to be destinations, it's suppose to be larger areas. So plotting an entire address doesn't really make sense.
9 Replies
It seems you already researched the subject pretty thoroughly. You can't have filled map and bubble map at the same visual.
I'm not sure what you mean by the 4th level, could you explain more thoroughly?
Best,
Martin
Dear Martin,
Thanks for the quick reply, I am working on filled map and facing some strange problem. Please see "Mydata.png" and "MyMap.png" enclosed herewith for clarification:
Even though I have the state data in the format of "State, Country Code". The filled map is marking "Sri Lanka" states in "Ireland" (left hand top corner)
You can see I am trying to map the 4th entity as "Zip code 2" ==> This is not working.
Thanks,
Prasanna V.
This approach has worked for me before:
Column = Postalcode&" "&Country
or
Column = Postalcode&" "&Countrycode
Try this and get back to me.
