Forum Discussion

gaznez's avatar
gaznez
Resolver I
3 years ago
Solved

Display extra information in tooltip (map visualisation)

I have a working model that includes a map visual showing where all the customers are.  The map has 'postcode' as the Location, 'Total Sales' for the bubble size and 'Customer name' as the tooltip.  So when you hover over a bubble it tells you the postcode,  Sales value and 'First customer name'.  We have some postcodes where there is more than 1 customer.  Is there any way to get the tooltip to show all of the customer names at that postcode?

Need Help
  • gaznez's avatar
    gaznez
    3 years ago

    Managed to find a solution myself.  I created the following measure:

    ConcatCustomers = CONCATENATEX(
        CustomerMaster,
        CustomerMaster[Customer Name],
        ", ")
    Then I dragged this measure in to the tooltip field for the map visual.  Now if one postcode has several customers - it lists them all separated by a comma.

1 Reply

  • gaznez's avatar
    gaznez
    Resolver I
    3 years ago

    Managed to find a solution myself.  I created the following measure:

    ConcatCustomers = CONCATENATEX(
        CustomerMaster,
        CustomerMaster[Customer Name],
        ", ")
    Then I dragged this measure in to the tooltip field for the map visual.  Now if one postcode has several customers - it lists them all separated by a comma.