Organising data so my columns link to coordinates (map visualisation)

[Anonymous]

Hello,

I am new to PowerBI, I am trying to organise my data in excel so when creating a map visualisation I can click on various locations and then get values to come up on a multi-row card to display data insights of that area which has been selected on the map.

So far I have my lat and long coordinates in separate columns, then my data which I want to relate to areas on the map is in separate columns. Each area is organised by rows as shown below.

Any help would be greatly appreciated,

Thanks 

[Anonymous · Accepted solution]

Hi @Anonymous ,

You may try to directly put the information you want to display on the tooltips of the map visualisation.

Or you may try to create tooltips based on report pages.

You can check more details from here.

Reference: Customize tooltips in Power BI Desktop

                 Create tooltips based on report pages in Power BI Desktop

Best Regards,

Stephen Tao

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

[negi007]

@Anonymous You can easily create a geolocation map using the data that you have. Below is the similar chart for your reference.

[amitchandak]

@Anonymous , not able to get the issue. You can plot same on Map using lat  log.

Can you share sample data and sample output in table format?

[Fowmy]

@Anonymous 

You need to unpivot the columns have the desired result:

Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?

_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn