cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Zerosum Frequent Visitor
Frequent Visitor

Mapping Errors - Incorrect Locations

Hello,

 

I am trying to make a map with a drill down on a map of the US. I have the levels as Region -> Market (hoping to add one more layer next). Originally the regions were not getting mapped correctly ie 'US West' was in a random location not really indicative of its name so I created a column to manually to specifcy an exact location for the regions and it worked.

 

When I drill down another level the bubbles are stacking on top of each other and I've tried changing certain market names to something more exact: City, State, US; City, Zip Code; and (Lat, Long). It seems like only one of the replacements worked and I can't get the others to be placed correctly. I looked at some previous posts and they had used just zip codes but that does not seem to work either. I am pretty new to Power BI so I'm not even sure if I'm approaching this correctly.

 

US Region view

Region_1.png

 

Market ViewMarket_1.png

 

My last question is -- is it possible to add a third drill down using lat and long for the locations? I've tried creating a hierarchy with lat/long and placing that into the Location and it doesnt seem to work. Is there a way to combine them into a single element "lat, long" and append it to the location section? I tried it, but it could be possible I have the format incorrect.

 

The only other way I thought of is if a market was selected, was to drill through into another map that had all the lat/long coordinates.

 

Any help would be appreciated! Thanks!

 

 

 

1 REPLY 1
Anonymous
Not applicable

Re: Mapping Errors - Incorrect Locations

I think this article will be very useful for your scenario.

 

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors