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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Address Data Not Working In Maps

Hi,

I have address data that won't display on powerbi desktop maps. Here is link to sample data

I've tested this sample data (sourced from another thread in the forum) and it works fine so not sure why my sample data isn't working even though it contains Long/Lat values. I've also categorized some columns accordingly i.e. City as "City", Address as "Place"/"Location", Long/Lat as "Longitude" / "Latitude"

Can someone please test my sample dataset?

Appreciate any help. Thanks.

1 ACCEPTED SOLUTION

HI @Anonymous 

 

It was your first filter. I used the select all option now. This resolves your issue

pranit828_1-1597877532398.png

 

You have to select the month week filter which has data.

 

 





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

View solution in original post

6 REPLIES 6
pranit828
Community Champion
Community Champion

HI @Anonymous 

Either use City or latitude, longitude

 

I would use the map visual, converted the data type to latitude and longitude resp and it worked.

pranit828_0-1597876479926.png

Also, don't summarize both latitude and longitude.

pranit828_1-1597876548342.png

 





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile
Anonymous
Not applicable

Hi @pranit828 I did try that too but still didn't work...I provided link to pbix file in my previous response

HI @Anonymous 

 

It was your first filter. I used the select all option now. This resolves your issue

pranit828_1-1597877532398.png

 

You have to select the month week filter which has data.

 

 





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile
Anonymous
Not applicable

Hi @pranit828 and @Greg_Deckler, thank you for the solution, it worked. Careless mistake on my part and sorry for the trouble. 

Appreciate both your time:)

Greg_Deckler
Super User
Super User

@Anonymous - At first glance, things look OK. Check the PBIX file attached below sig. Is there a particular location that you are having issues with?

 


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...
Anonymous
Not applicable

That's so weird, its still not working for me. I don't see an option on my end to attach pbix file so here is link to file

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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