Power BI Map Help

[W2SANC]

Hello! 

I am reaching the Power BI delierium stage of knowing the solution is likely really simple (and my error is silly). Please help me regain my sanity. 

I have a dataset that basically shows sales (count and amount) at the transaction level across the United States. I want to use the map visual to create the dots (based on amount $) to viusally see where all sales are, and where most money (amount) of sales are going. 

I have a Census Tract column, county column, state column, zip code column, and a merged county, state column. When I go to make the map visual - it shows up oddly and all over the globe. I am not sure where I am going wrong currently. 

I copied that same dataset and grouped by state and county (county, state) and was able to make a table that summed up the total sales amount by county, state - but the map visual is not working. 

What am I doing wrong?

Thanks in advance. 

[v-venuppu · Accepted solution]

Hi @W2SANC ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-venuppu]

Hi @anilelmastasi   ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @anilelmastasi for the prompt response.

After creating a calculated column as suggested by @anilelmastasi as below:

Create a calculated column that clearly identifies each location. Like below formula:

CountyState = [County] & ", " & [State]

• After creating the column, click on it (just select it in the Fields pane).
• Now go to the Modeling tab at the top ribbon.
• In the Modeling tab, look for Data Category, and from the dropdown choose "Place" or "County".

  Please find the below screenshot for your reference: 

  

  If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

  Thank you.

[W2SANC]

Hello - 

I have changed some of the relationship connections on the backend, and that has helped keep it within the US (yay!) - now my only question is - I was hoping to have the map that showed circles (where the larger the circle indicates larger $ deployed in that place). See in the attached photo that I currently have shaded in counties/places, and for my purposes, this isn't the most helpful visual. I also am not 100% what shaded means (darker color saturation = more $?) 

[anilelmastasi]

Hello @W2SANC ,

You are currently using Filled Map. Shading = relative intensity (darker = more $ deployed)

But what you want is Bubble Map. This is the standard “Map” visual, not the “Filled Map.”

You can swith to map with:

In the Visualizations pane, change from “Filled Map” to “Map” (looks like a globe icon 🌐)

In the Fields pane, configure it like this:

Location: County name

Size: $ Deployed (your numerical field)

Set Data Category on the Location column to “Place” or “County”

If this solved your issue, please mark it as the accepted solution. ✅

[W2SANC]

Thank you! I did that can got the visual results I wanted. BUT, there are still a few dots that show in other counties (see below photo). 

I'm not sure how to fix those specific data points. See below. If I hover over those points, it still has labels as County, State in the US (example - Albermarle, Virginia) 

[anilelmastasi]

Hello @W2SANC ,

Create a calculated column that clearly identifies each location. Like below formula:

CountyState = [County] & ", " & [State]

-Use this column in your map visual’s Location field.

-This helps Power BI avoid confusion between counties with the same name in different states (e.g., there are 30+ Washington Counties in the US).

After that:

Select your CountyState column

Go to the Modeling tab > Data Category → Set to Place or County

If this solved your issue, please mark it as the accepted solution. ✅

[W2SANC]

Hello! Can you do a little bit more of a step by step on this part: 

After that:

Select your CountyState column

Go to the Modeling tab > Data Category → Set to Place or County 

Where do I select the county state column (County, State) ? in the modeling tab?

[anilelmastasi]

Hello @W2SANC ,

Could you please send a screenshot of error?

What error do you get when you want to creat map visual?

At Data View you can select:

Column        Data Category

-------------------------------

State            State or Province
Zip Code     Postal Code
County         County

[W2SANC]

See the thread above - I fixed the visual aspect, but still have a few points showing in other countries but when you hover, it still shows locations in US (Ex: Albermarle, Virginia) but shows in South America.