How can I remove Lat Long and replace with work order number for each bubble on map?

[Anonymous]

The tool tips works great when mousing over a bubble, however, I would rather show a Work Order number instead of Lat Long data for each bubble.  I do have tools tips working but I have to mouse over bubbles to see the Work Order Number first.

I would like each Lat/Long bubble to display the Work Order Number only above it.

ToolTips work great - want to add Work Order # only to each bubble.

[v-rzhou-msft · Accepted solution]

Hi @Anonymous 

You can add Work Order number into location and turn on Display category labels in Format.

And you need to summarize Latitude and Longitude by average.

My Sample:

Fields:

Format:

Result is as below.

Best Regards,

Rico Zhou

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

[Slimbrady]

going to update this thread since the other replys are a couple of years old. . . 

You can remove the Lat Long by following these steps.

Once added in the map for the Lat and Long settings in the settings form, you can right click the lat and long and then move it to the tooltips shelf.  Once in the shelf, you can remove it from the Tooltips section and map still works and does not shwo the lat long in the map Tooltip.

[Anonymous]

RicoZhou...your solution here worked beautifully.  The average summary was required for Lat and Long data.  I would have never figured that out since I dont understand why an average sum of that data is required.  But, bottom line, your solution worked and looks great.  Exactly what I wanted. Here is a small screenshot of the icons with work order numbers tagged to each location.  Thank you! I think I may have selected the wrong solution but couldnt figure out how to change it. Working with this blog on my phone is difficult.

 

[parry2k]

@Anonymous you can create your own custom report tooltip page and use that in your visuals. Read more here on how to create a custom report tooltip page.

CHECK MY LATEST BLOG POST Year-2020, Pandemic, Power BI and Beyond

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[PhilipTreacy]

Hi @Anonymous 

I don't think that can be done.  If you turn on Category under Format, you'll just see the Lat and Long displayed.

Regards

Phil

[Anonymous]

Philip:

That is indeed the problem I am running into for now.  Thanks

[Anonymous]

RicoZhou's answer did the trick.