Forum Discussion
Helper IIIMore than one tool tip item on map
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
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
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
v-yanjiang-msftCommunity Support
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
