Forum Discussion

Icon for Helper IV rank

Helper IV

9 years ago

Solved

How to display data at different lines on Map bubble's labels?

How to show the company info and address info on the above bubble label at different lines, as the following format:

COMPANY Cambridge Travel Lines

17 Hiwi Rd, Tauwhare, Hamilton, New Zealand

Thanks.

Vvelarde
9 years ago
j_w

The error appears because is you have same adress to two or more companies.

Change the measure to control this:

CompanyName = CONCATENATEX(VALUES(Table2[Company Name]),Table2[Company Name],",")

9 Replies

Vvelarde
Community Champion
9 years ago
j_w

hi, One Question: Do you have Company Id and Adress Info in one Column(field)?

I saw that you have 2 columns Company ID and Address Line.
- j_w
  Helper IV
  9 years ago
  Vvelarde
  
  Hi, I haven't used the field Address Line.
  
  But I set CompanyName and Address info to one field Company using SQL statement like:
  SELECT "COMPANY NAME"+'\n\r'+"ADDRESS LINE" AS Company, ... FROM COMPANY WHERE ...
  
  Because I have troubles if I use two different fields, as described at
  https://community.powerbi.com/t5/Desktop/How-to-show-multiple-fields-value-on-the-map-bubble-info-window/m-p/124878#M52862
  - Vvelarde
    Community Champion
    9 years ago
    j_w
    
    If you want to see the Company in tooltip
    
    Create a measure
    
    Company=Values('nameoftable'[CompanyName]) and put this measure in tooltip.
    
    No need to join in one field