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

[j_w]

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]

@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]

@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-wi...

[Vvelarde]

@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

[Vvelarde]

[j_w]

@Vvelarde

Thanks, your solution is perfect.

But how can you set Tooltips as Text? As you can see, mine Company field for Tooltips is treated as numbers, and I cannot find where to change it?

[Vvelarde]

@j_w

Create a measure

Company=Values('nameoftable'[CompanyName]) and put this measure in tooltip.

[j_w]

@Vvelarde

Tried to work it out, but there is an error message after I using measure. Not sure where needs to be modified?

[Vvelarde · Accepted solution]

@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],",")

[Anonymous]

@Vvelarde@j_w Any way to remove the default tooltip fields ? I do not need to show the latitude and longitude in the tooltip.