How to Enable Filled Map in Power BI

Creating a map that shows sales by state or website traffic by country is one of the quickest ways to spot geographic trends in your data. While Power BI makes this simple with its Filled Map visual, getting it to work correctly requires a few specific steps. This tutorial will walk you through exactly how to prepare your data and enable filled maps to bring your location-based insights to life.

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 Use a Filled Map in the First Place?

Before jumping into the “how,” let’s briefly cover the “why.” Unlike a standard map that places a bubble or dot over a location, a filled map colors an entire geographic region - like a state, country, or postal code area. This makes them incredibly effective for:

• Comparing values across regions: Instantly see which states have the highest sales or which countries generate the most leads by assigning colors based on value.
• Visualizing distribution and density: See market penetration or customer concentration at a glance. For example, a map of your e-commerce customers can instantly show where your brand is most popular.
• Telling a simple geographic story: Filled maps are easy for anyone to understand. They immediately answer the question, “Where are things happening?” without requiring users to interpret the size of scattered bubbles.

In short, if your data has fields like Country, State, County, or Zip Code, a filled map is likely the best way to visualize it.

Data Preparation: The Key to a Perfect Map

The single most common reason Power BI filled maps fail to appear is incorrectly prepared data. Power BI’s mapping service, which is powered by Bing, needs a definitive signal to know that a column of text like "California" or "Germany" refers to a geographic location.

This is where Data Categories come in. Before you even touch a visualization, you need to tell Power BI what kinds of locations are in your columns.

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

How to Set Data Categories

Let's say you have a simple sales table with columns for Date, Product, Sale Amount, and State. Power BI sees "State" as just a text column by default. To fix this, you need to categorize it.

Follow these steps:

1. Load your data into Power BI. From the main report view, click on the Data view icon on the left-hand sidebar (it looks like a small table).
2. In the Data pane on the right, find your table and click on the column containing your geographic data (e.g., 'State' or 'Country').
3. With the column selected, a Column tools tab will appear in the top ribbon.
4. Look for the Properties group and click the Data category dropdown menu. It will default to "Uncategorized."
5. From the list, select the appropriate category for your data. Power BI has options for Address, City, Continent, Country, County, Place, Postal Code, State, and more. For our example, you would click State or Province.

That’s it! A small globe icon will now appear next to your column name in the Data pane, confirming that Power BI recognizes it as geographic data. This single step solves about 90% of all "filled map not working" issues.

Pro Tip: For best results, use standard, unambiguous names. "United States" is better than "US" or "USA." "California" is better than "CA." If Bing Maps can't figure out your location, your map will be blank.

Step-by-Step Guide: Creating Your First Filled Map

With your data correctly categorized, building the visual takes just a few clicks.

1. Select the Filled Map Visual

Back in the Report view (the top icon on the left sidebar), go to the Visualizations pane on the right. Find and click on the Filled Map icon. It looks like a globe with some regions shaded in. A blank map wireframe will appear on your report canvas.

2. Add Your Data Fields

Now, let's bring the map to life. With the new map visual selected, you’ll see several fields available in the Visualizations pane underneath the icons: Location, Legend, Latitude, Longitude, Color saturation, and Tooltips.

• Drag your categorized geographic field (e.g., "State") from the Data pane and drop it into the Location field. At this point, Power BI should draw the boundaries for each state in your dataset and give them all a default color.
• Next, drag the measure you want to visualize (e.g., "Sale Amount") and drop it onto the Color saturation field. Power BI will automatically color each state based on its total sales volume - darker for higher sales, lighter for lower sales.

And just like that, you've created an insightful filled map!

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

Customizing Your Filled Map for Clearer Reporting

A basic map is a good start, but Power BI gives you plenty of formatting options to make it more professional and easier to understand.

Select your map visual, then click the paintbrush icon (Format your visual) in the Visualizations pane. Here are a few key adjustments you should almost always make:

1. Improve Your Colors: Go to Fill colors in the formatting options. By default, Power BI uses a sequential color scale. You can change the minimum and maximum colors here. A great feature is the Diverging option. By toggling this on, you can set a center color, which is perfect for showing positive and negative performance against a target.
2. Add a Meaningful Title: Expand the General options, then Title. Replace the default title (like "Sum of Sale Amount by State") with something more descriptive, such as "Total Sales by State - Q3 2023."
3. Refine Map Controls: Under Map settings > Controls, you can turn on Auto zoom (which is great!), as well as give users Zoom buttons so they can explore the map themselves.
4. Enhance with Tooltips: The tooltip is the small box that appears when you hover over a region. By default, it will show the state name and the sales amount. You can provide more context by dragging other fields into the Tooltips data bucket. For example, add "Number of Customers" or "Average Order Value" to give users deeper insights directly on the map.

Take a few minutes to adjust these settings, and your visualization will go from simply functional to professionally polished and highly informative.

Troubleshooting Common Problems

What if your map is blank, dots appear in the wrong place, or some regions are missing? Here are fixes for the most common issues.

Problem: My Map is Blank or Only Shows One Region

• Cause: This is almost always a Data Category issue. Either you forgot to set it, or the location names in your data are ambiguous or misspelled.
• Solution: Double-check that your location column has the correct Data Category assigned. If it does, scan your data for typos ("Unted States" instead of "United States").

Problem: Data Points Show Up in the Ocean or the Wrong Country

• Cause: Bing Maps is confused by ambiguity. For example, if you have "Paris" in your data, it doesn't know if you mean Paris, France, or Paris, Texas.
• Solution: Be more specific! The best way to resolve this is to create a more complete location. If you have "City," "State," and "Country" columns, you can either:

Problem: Some of My Regions Are Uncolored or Gray

• Cause: This usually happens when you have a value of zero or blank for that region in the data you're using for color saturation. Power BI, by default, doesn't color these. It could also be that a location name does not match what Bing Maps is expecting.
• Solution: Check your source data to confirm that there is indeed data for the missing region. If data is present, go back to the formatting options -> Fill colors -> and set the color for the lowest value. Ensure ‘0’ or missing values isn’t being rendered a neutral color.

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

Alternative: The Shape Map

Sometimes, the Filled Map just won't cut it, especially if you have custom territories (like "Eastern Sales Region") or non-standard areas. For these cases, Power BI has another visual called the Shape Map.

This visual lets you upload your own custom map files in a format called TopoJSON. You map your data to the custom shapes, this could be anything from store floor plans to bespoke sales territories. While it requires finding or creating a TopoJSON file, it offers ultimate flexibility when standard political boundaries are not enough.

Final Thoughts

Creating filled maps in Power BI is a fantastic way to quickly visualize geographic trends, but its success boils down to telling the tool exactly what kind of location data it's looking at. By correctly setting the Data Category and using standard location names, you enable Power BI to effortlessly translate your rows of data into rich, intuitive maps that an audience can quickly understand.

We know that connecting all your data sources and getting them ready for visualization can be a time-consuming grind - never mind mastering tools like Power BI. That's why we built Graphed. Here, you connect your sources like Google Analytics, Shopify, or Salesforce once, and then simply ask for what you need in plain English. Instead of manually clicking, categorizing, and formatting, you can just ask, "Show me a map of customers by state from Shopify for the last 90 days." Graphed generates the dashboard for you instantly, helping you go straight from data to decision without all the manual setup in between.