Issue with Icon Map Drill Down with repeated index

[jbaisley]

Hello folks!

A very very niche issue for you. I have a data table like below.

Region	Local authority	Company Name
London	Lambeth	A
South West	Devon	B
South West	Devon	C
South West	Cornwall	D
South West	Cornwall	E
South East	Guildford	F
South East	Chichester	G
North East	Middlesbrough	H

So we have a repeated index for region and local authority for each unique company. In Icon Map I then have 3 unique layers; two geojsons and a circle layer for company lat/long (not included in the table above). I have been able to create a label measure that allows me to swap between labels as you drill down layers from Region > Local Authority > Company Name. The code of the label function is below.

Label = SWITCH (TRUE, ISINSCOPE(Partner_Data[combi_lat_long]), MAX(Partner_Data[Company name]), ISINSCOPE(Partner_Data[Local authority]), MAX(Partner_Data[Local authority]), ISINSCOPE(Partner_Data[Region]), MAX(Partner_Data[Region]), "unknown")

The layers correspond to different geojson layers:

• combi_lat_long = Is the most granular and allows for point based mapping (Lowest)
• Local Authority = For the Local Authority Shape (Middle)
• Region= The wider UK region label at the most aggregated level. (Highest)

And this works well! So no issues there. The problem is then if you add a slicer. As soon as you then filter an item the labels may swap positions. London moving to Cornwall, and Liverpool to Manchester. I have no idea what is causing this other than the 'MAX()' function above. I assume as we filter other variables in the table the logic it is not finding a unique label and doing weird and whack things behind the scenes I cannot see. 

If I create a table and test the slicer, everything is coming out consistent, but as soon as its in Icon Map it does this weird swapping, which also happens at all levels.

Anyone have this issue or an idea as to how to fix my label logic to make it consistent at any given level?

[Anonymous]

Hi @jbaisley 

What does this field Partner_Data[combi_lat_long] correspond to? You don't have data about this field in your data table. The situation you're talking about only exists with Icon Map, right?

Best Regards,
Community Support Team _ Ailsa Tao

[jbaisley]

Sorry Ailsa, 

• That column corresponds to a concatenation of latitude and longitude to create a granular layer where items are plotted as points (I have edited the original post)
•  
• By way of a update as well. It appears to be the way a Power BI data frame maps to the shape. If you filter the data set, it doesn't filter the data connected to the shape, so using the MAX() fucntion just assigns a label to the blank shape. I am looking for a way to only hold and assign unique values.