Forum Discussion
Duplicating Map Legend
Hi,
My map seems to be duplicating each point on the map when both of my legends are selected.
So, I'm placing a pointer on a map to say that one is a client and the other is not a client. When I slice the data by Is Client/Is Not Client, the data shows correctly. But when I select both, rather than the map showing both points in different colours, it is duplicating each instance and splitting the colours in half to say that one instance is both a client and is not?
But when I select one or the other, they show correctly and don't duplicate. I've placed the same location when selecting is not client and is client and you will see that they show correctly.
But now when I select both IS and ISN'T the duplicates happen again:
Does anyone know why this is? There are no duplicate instances in the data, hence they are showing correctly when one or the other is selected, just not both.
Would appreciate any help! :)
Francesca
You are welcome! :smileyhappy:
One more thing you may consider is concatenating columns into a new column solely for Tooltip Use.
So first create a Column by concatenating the information you want to show in the Tooltip and then use this new column in a Measure!
Hope this helps! :smileyhappy:
14 Replies
Try writing a measure with CALCULATE to filter out the Client Instance with Isn't Client instance. and use that measure on your map
Something like this..
Measure:=CALCULATE(COUNT(INSTANCE),FILTER(TABLE,TABLE[INSTANCENAME]="CLIENT")
and see how it goes..
teatree This is most likely because you've left the Size field empty.
You need to Leave the Location field blank
Legend - Client/Is not Client column
Lat - Latitude (Do Not Sum) with this set up
Long - Longitude (Do Not Sum) with this set up
Size - If you want them all to be the same size just drag the Client/Is Not Client column to create a Count of...
I think this should do it! :smileyhappy:
Hi Sean,
I have additional data in the location field such as the Establishments Name and the Customer Code so that they show when hovering over, that way I can see that a) the circle is green so they are a client, and b) what the clients customer reference is.
In response to the measure, I'm not too sure I understand what you mean as I can't use the measure as a legend, unless I'm misunderstanding?
