Forum Discussion
Map visuals: more data (bubbles) showing than expected
Hi lbendlin
The many-to-many relationship between the events and schedulers [same for the other one] was selected by Power bI. When I try to change the relationship for events and schedulers to be many to 1 considering many events can happen to one pipeline [1 scheduler takes care of 1 or more pipeline(s) ], it doesn't let me change the relationship [PFB]
Thanks. ~Sohana
Hi all: I also have questions on 'Map' [regular map] visual:
1. what should i use for 'Location'?
2. for longitutde/ latitude: which one I use- min/max/average?
3. Do I have to make the category of latitude/longitude/county/state/ in 'Data' view-> Model-> Category-> right category e.g Latitude/Longitude/county/state etc. rahter than leaving those 'uncategorized'? I haven't seen any difference so far!
Thanks. ~Sohana
- v-easonf-msft
Community Support
Hi , Anonymous
It's better to recheck your data type, summarization and data category.
You may check if this tutorial helps.
https://radacad.com/how-to-do-power-bi-mapping-with-latitude-and-longitude-only
Best Regards,
Community Support Team _ Eason
- lbendlin
Super User
That means you either have a data quality issue in your data, or you may need to rethink the entire project. Generally you want to have a data model that is at least resembling a star or snowflake schema, with "dimensions" on the one side of a relationship and "facts" on the many side.
