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
markc
Frequent Visitor

Map issue - location name

This might be something low on the list as the userbase would be small but I have run into an issue with the map visual.

 

In Louisiana, we don't have "Counties", we call them "Parishes". (The nomenclature goes back to the Louisiana Purchase.) I developed a report using the filled map visual. In my query I brought over my FIPS data where the column is called "county_name". Everything works great. However when I added an alias to it so that the column would be shown as "Parish Name" the map went blank like it didn't know where the locations were.

 

Works:

select county_code
from data

 

Doesn't Work:

select county_code 'Parish Name'
from data

When I removed the alias, the map refreshed and brought back the shaded areas.

 

Like I said, this might be a trivial fix but it would mean the world to those of us creating a reports in Louisiana.

 

Thanks

 

 Mark

3 REPLIES 3
Sean
Community Champion
Community Champion

I have no problem mapping all Parishes with the built-in Regular and Filled Map and ArcGIS too

 

The Column itself is called Parish and as you can see in the Legend the rows in the Parish Column say Parish too not County

 

Parishes.png

 

EDIT: Well with some small modifications even the Shape Map works

remove the word "Parish" from all rows in the column - column can still be called Parish though

replace all "Saint" with "St." and "La Salle" with "LaSalle" no space and there it is Smiley Happy

 

Parishes2.png

 

markc
Frequent Visitor

I am curious as to what is in the table or the JSON file you used. Does it have the coordinates or anything else in it? Or is it strictly the parish names?

 

I tried using the parish name minus the ' Parish' part and it still failed to associate correctly.

 

Thanks.

Sean
Community Champion
Community Champion

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.