More than one tool tip item on map

[Jay2077]

Ok so i have a map of stores and i want to display items - putting stores column in tool tips gives me first or last 

1. How do I get more than first or last say there's more than 2 items 

2. How do i get it to show nothing if they only have one item. 

Any help greatly appreciated 

[v-yanjiang-msft · Accepted solution]

Hi @Jay2077 ,

According to your description, I create a sample.

There are two stores of the city London, other cities have only one store.

In my understanding, you want the tooltip of London shows both store A and store C, but other cities show nothing.

Here's my solution, create a measure.

Store' = 
IF (
    COUNTX (
        FILTER ( ALL ( 'Table' ), 'Table'[City] = MAX ( 'Table'[City] ) ),
        'Table'[Store]
    ) > 1,
    CONCATENATEX ( 'Table', 'Table'[Store], "," ),
    BLANK ()
)

Put the measure in the map tooltip, then get the expected result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Jay2077 , You can use measure using concatenatex

concatenatex(Table, Table[Store], " ,")

or you can try tooltip page https://docs.microsoft.com/en-us/power-bi/desktop-tooltips