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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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!:
The Definitive Guide to Power Query (M)

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.