Good day! I have a summary “Table” visual that shows some ‘Events’ for a ‘Scheduler’ [should be notified] for the ‘Pipelines’ they work on.. E.g. there are 3 events for a scheduler, XYZ. Now, I have a “Map” [regular map] that shows those events as bubbles in the map. For the ‘Map’: I have a slicer for date range, another slicer for the schedulers [drop down for all or a specific one], a slicer for pipelines [drop down list]. But, I see more bubbles (e.g. more than 3 for scheduler, XYZ) on the map. I am using 3 different data sources: DS1: events, DS2: pipeline locations & DS3: schedulers The relationships are:
Many to many between DS1 & DS2 [on pipeline name], Many to many between DS1 & DS3 [on pipeline name]
For the Map: For ‘Location’ field, I tried to use ‘loc_name’ or ‘location_id’ [from DS2] - but that probably is causing more bubbles to show up than the actual one. I changed the map to a ‘Table’ visual and found for same ‘loc_name’ or ‘location_id’ the events are calculated multiple times!
I changed ‘Location’ field to have ‘event summary’ from DS1. It shows less bubbles now but they are on top of each other and no map shows up [kinda a board with bubbles]! For map visual-> what should I do that I may have been missing?
Much appreciated in advance!
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]
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!
Hi , @sohananahid
It's better to recheck your data type, summarization and data category.
You may check if this tutorial helps.
Community Support Team _ Eason
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.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.