Stacked Symbols at Same Location

[BillyJ]

Since the most recent ArcGIS Maps for Power BI update, we have been experiencing an issue visualising multiple records at the same location. The issue is that the symbols now stack on top of one another with just one of them being visible, and no ability to toggle between records on the tooltip. Previously, records at the same location had a count of the number of records at the location (e.g. 1 of 4) and a left and right arrow to toggle between the different records and symbols.

Below is a sample dataset used to illustrate the issue.

Both Customer A (red) and Customer B (blue) are at the same location, and when no filters are applied the symbol for Customer A is showing (a red circle), but the tooltip information displays the name of Customer B. There is nothing visible on the symbology or the tooltip to denote that more than one record exists at this location.

When slicers or filters are applied, the individual customers (and their associated symbols) are visualised as expected.

We are looking for a solution that allows users to identify that more than one record exists at the same location, and ideally the ability for the user to toggle from one record to the next without needing to apply a filter (as per previous releases of ArcGIS Maps for Power BI).

Below is a screenshot of how this used to appear

[NaZhang_Esri]

Hi @BillyJ ,

Thanks very much for your question! Please see a solution here and let us know if this works for you. https://community.esri.com/t5/arcgis-for-power-bi-questions/urgent-unable-to-navigate-between-the-to...

[JepchumbaKoech]

I am having a similar issue with Country fields. My map is still showing the first record for each Country. Is the behavior similar for customers using lat/long fields and location fields?

[NaZhang_Esri]

Hi @JepchumbaKoech ,

Thanks for your question! If there are more than one Power BI record for one feature(per country in your case), then it shows only one record. Have you tries the solution here? https://community.esri.com/t5/arcgis-for-power-bi-questions/urgent-unable-to-navigate-between-the-to... 

Here's an example of multiple cities in one state.

[JepchumbaKoech]

Yes, got it now! Thank you for the clarification. 

[AlagiriVenkatachal]

Hi @BillyJ ,

In addition to the post that @NaZhang_Esri pointed out, I am uploading a sample .pbix file that demontrates setting up the report page tooltip. It has two pages:

1. Report page with the Esri Map; data mapped using Lat and Long field.

2. Tooltip page with tabular data.

When hovering over points on the Map, a tooltip is shown as  a table using the tooltip page including stacked features.

In addition, I also want to point you to a post in the Power BI community that helped with setting up the filter on the Tooltip page so that when you hover a feature on the Map, the tooltip is shown for all features. Since you are using the Lat and Long fields, you will want to add those fields to the Filter field well in the Tooltip page as indicated in the below link as a Category. 

https://community.fabric.microsoft.com/t5/Desktop/Tooltip-for-Stacked-Column-Chart/m-p/938189/highli...