Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
TomBelgium
Helper I
Helper I

Can't get coordinates correctly on map

Hi all,

 

I have a large dataset with BLE beacons (TagText) and per beacon the historic location (LAT, LON) and the time seen at that location.
I want to have a visual where I can see how the beacon travelled and another map which would be the heatmap of all beacons at their last seen location.

I imported the data and have a dataset as follows:

TomBelgium_0-1686747823405.png

I assign the LAT & LON field to their correct data category

TomBelgium_1-1686747866514.png

 

 

Than I just drop the LAT & LON in the corresponding visual fields.
Than I get a map with three points and when I hover over it, the tooltip gives me 358 different coordinates. 

TomBelgium_2-1686747947304.png

 

 

I would expect all these points to be separate. I choose to not sum the data

TomBelgium_3-1686747977944.png

 

 

When I add the datetime field to the TIME Field on the visual, I get a timebar but it doesn't show correct points either.

 

Another thing I tried, was the normal map visual. But when I add LAT & LON, nothing seems to happen on the visual.

Help is needed 🙂

 


Thx in advance for all tips & tricks.

2 REPLIES 2
Greg_Deckler
Super User
Super User

@TomBelgium Perhaps add an index column or use the time field in the Legend?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

I just played around a bit and finally managed to do both somehow. 

Apparently the field was set as text. After changing it to decimal, it seems to work.

TomBelgium_0-1686749018583.png

 

So, I can start playing around! 

Thx

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors