How to Change Data Type to Geography in Power BI

Mapping your business data is one of the most powerful ways to spot trends you'd otherwise miss, but Power BI needs a little help to understand your location information first. To get those beautiful, insightful maps, you first have to tell it which of your data columns represent a place. This article will walk you through exactly how to change a data type to geography in Power BI, troubleshoot common issues, and start building visuals that tell a clear story.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Bother with Geographic Data?

Before jumping into the "how," let's quickly cover the "why." Translating lists of cities, states, or countries into points on a map isn't just a gimmick, it provides immediate context and reveals patterns that are almost impossible to see in a spreadsheet. With geographic data, you can:

• Visualize Sales Performance: Instantly see which regions are your top performers and which are lagging. A map showing sales concentration by state is far more impactful than a simple table.
• Identify Customer Clusters: Discover where your customers are physically located. This can inform marketing campaigns, sales territory planning, and even decisions about where to open new physical locations.
• Analyze Operational Logistics: Track supply chain routes, warehouse locations, and distribution networks. Seeing this data geographically can highlight inefficiencies or opportunities for optimization.
• Understand Demographic Trends: Overlay demographic information on a map to see how population density, income levels, or other factors correlate with your business metrics in specific areas.

In short, converting text-based locations into a map visual turns abstract data into a tangible, strategic tool. The first step in that process is setting the right data category.

Understanding Power BI's Data Categories

Out of the box, Power BI imports most text columns as a generic "Text" data type. When you load a column named "City" containing names like "London" and "Tokyo," Power BI just sees a list of words. The Data Category feature is how you give these words meaning.

By assigning a geographic category, you're giving Power BI a hint, saying, "Hey, this isn't just any text — this column represents a specific type of place in the real world." Power BI then uses this hint to interact with Bing Maps to find the correct coordinates and plot your data accurately.

The main geographic categories you'll use are:

• Address: For a full street address, like "123 Main St, Anytown, USA 12345."
• Place: A more general locator, often a landmark or establishment name. Less commonly used.
• City: For city names (e.g., "Paris," "Sydney").
• County: For county names (e.g., "Los Angeles County").
• State or Province: For state or province names (e.g., "California," "Ontario").
• Postal Code/Zip Code: For postal codes (e.g., "90210," "SW1A 0AA").
• Country/Region: For country names (e.g., "United States," "Germany").
• Latitude: For numerical latitude coordinates (e.g., 34.0522). Must be used with a Longitude column.
• Longitude: For numerical longitude coordinates (e.g., -118.2437). Must be used with a Latitude column.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

A Step-by-Step Guide to Changing Data Types

Ready to get started? We’ll use a simple example of a sales dataset in an Excel file that has columns for City, State, and Country. Let's get it mapped.

Step 1: Load Your Data into Power BI

First, you need to get your data into Power BI. If you haven't already, open Power BI Desktop and go to the Home tab. Click Get Data and choose your data source (e.g., Excel workbook, CSV text file). Navigate to your file and load the relevant table into your model.

For our example, let's say our table is called 'SalesData' and it contains columns like 'OrderID', 'TotalSales', 'City', 'State', and 'Country'.

Step 2: Navigate to the Data View

Power BI has three main views on the left-hand side of the screen: Report, Data, and Model. To change data categories, you need to be in the Data View. It's the icon that looks like a small spreadsheet or table. Click on it.

Here, you'll see the raw data in your tables, similar to how it would look in Excel or Google Sheets.

Step 3: Select the Column You Want to Change

From the Fields pane on the right, find your table ('SalesData') and click on the column you want to recategorize. Let's start with the 'Country' column. When you select it, the entire column will be highlighted in the table view.

Step 4: Use the 'Data Category' Dropdown Menu

Once you've selected a column, a new "Column tools" tab will appear on the top ribbon. Within this tab, look for the Properties section. You'll see a dropdown menu labeled Data category. By default, it will almost always say "Uncategorized."

Step 5: Choose the Correct Geographic Category

Click the "Uncategorized" dropdown. A list of all available data categories will appear. Scroll down to the geography options and select the one that matches your data. Since we have the 'Country' column selected, we will choose Country/Region.

You may notice a small globe icon appear next to the column name in the Fields pane on the right. This is your visual confirmation that Power BI now recognizes this column as geographic data!

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 6: Repeat for All Your Geographic Fields

Now, just repeat the process for your other location-based columns. Accuracy improves drastically when you give Power BI more context.

• Select your 'State' column, go to Column tools -> Data category, and choose State or Province.
• Select your 'City' column, go to Column tools -> Data category, and choose City.

Categorizing each of these tells Power BI how they relate to one another, which is critical for avoiding mapping errors.

Troubleshooting Common Mapping Problems

Sometimes, even after setting the data categories, your locations don't show up correctly on the map. This is a common frustration, but it's almost always fixable. Here are the most frequent culprits and how to solve them.

Issue #1: Ambiguous Locations

What if your data contains the city "Paris"? Power BI has no way of knowing if you mean Paris, France, or Paris, Texas. When there's only one location column, mapping services can get confused.

The Fix: Use Multiple Columns. This is why categorizing State and Country columns is so important. When you create a map visual, place your 'City', 'State', and 'Country' fields into the Location bucket of the visual. Power BI will now use the combination of a city, a state, and a country to find the precise location, removing the ambiguity.

Issue #2: Data Inconsistencies and Typos

Mapping engines require clean, consistent data. If your 'Country' column contains variations like "USA," "U.S.A.," and "United States," Power BI will treat them as three different places. The same goes for simple typos like "Californa" instead of "California."

The Fix: Clean Your Data with Power Query. The best place to fix this is in the Power Query Editor before the data even hits your model.

1. In the Home ribbon, click Transform data.
2. In the Power Query editor, select the column with inconsistencies (e.g., 'Country').
3. Right-click the column header and choose Replace Values.
4. In the dialog box, enter the value you want to find (e.g., "USA") and what you want to replace it with (e.g., "United States"). Repeat this for all variations.

This one-time cleanup ensures your mapping will be accurate and reliable going forward.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Issue #3: Working with Latitude and Longitude

If you're lucky, your dataset might already include precise coordinates. To map these, you need to categorize two columns.

The Fix: Categorize Both 'Lat' and 'Lon'. Follow the steps from before, but this time:

1. Select your latitude column and set its Data category to Latitude.
2. Select your longitude column and set its Data category to Longitude.

Now, when you create a map, drag the Latitude field to the Latitude well and the Longitude field to the Longitude well in the Visualizations pane. Power BI will plot the exact points for you.

Creating Your First Map Visual

Once your data is correctly categorized, the fun begins. Let's create a quick map to see our work pay off.

1. Click back to the Report View (the bar chart icon on the top left).
2. In the Visualizations pane, click on the Map icon (the one that looks like a globe).
3. A blank map visual will appear on your canvas. With it selected, go to your Fields pane on the right.
4. Drag your categorized 'State' field into the Location field well of the visualization. You should see dots appear on the map for each state in your data.
5. To make it more useful, drag a numerical field like 'TotalSales' into the Bubble size field well. Now, the dots will be sized based on sales volume, giving you an instant view of your top-performing states.

Just like that, you've turned a boring table into an actionable geographic insights report.

Final Thoughts

Properly categorizing your data in Power BI is a fundamental step that unlocks the full potential of its mapping capabilities. By simply telling Power BI that "California" is a State and "90210" is a Postal Code, you transform simple text into location-aware data ready for powerful analysis and visual storytelling.

Turning data into clear insights shouldn't feel like wrestling with software. Often, the biggest hurdles are the countless clicks, data cleaning steps, and learning curves of tools like Power BI. At Graphed, we've automated this entire process. Instead of manually categorizing columns and troubleshooting maps, you just connect your data sources and ask questions in plain English like, "show me a map of our sales by city for last quarter." Graphed instantly builds the live, interactive map for you, letting you jump straight to asking the next question instead of spending time on setup.