How to Make Power BI Map Look Better

Cody Schneider9 min read

Nothing tells a story with data quite like a map. But if you've worked with Power BI, you know that dragging your location data onto the canvas often produces a map that's just okay. It's functional but generic. This guide will walk you through the key settings and strategies to transform your default Power BI maps into professional, insightful, and visually appealing tools that make your data stories clear and compelling.

GraphedGraphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch Graphed demo video

Start by Choosing the Right Map for the Job

Before you dive into colors and bubbles, the most important step is selecting the right type of map visual. Power BI offers a few different options, and your choice will determine what customizations are available.

Map vs. Azure Maps: What's the Difference?

These two are the most common choices, and knowing when to use each is crucial.

  • Map (the standard visual): This is your basic Bing Maps integration. It’s perfectly fine for simple tasks like placing dots on a map to represent cities or showing bubbles scaled by sales volume. Think of it as the reliable, no-frills option. It's great for quick, straightforward visualizations where you don’t need deep customization.
  • Azure Maps (recommended for better looks): This visual is significantly more powerful and is the key to creating truly impressive maps. Built on Microsoft's Azure Maps service, it offers layers, different base map styles (like satellite and dark mode), heat maps, and real-time traffic overlays. If you want to make your map look better, you should almost always start with Azure Maps.

What About Filled Maps and Shape Maps?

These are more specialized and have specific use cases.

  • Filled Map: Use this when you want to show entire regions (like states, countries, or counties) shaded with color. A classic example is a US map where each state's color intensity is based on its total revenue. It's ineffective for showing specific city locations, as it will just color the entire state or country. It’s all about regional comparisons.
  • Shape Map: This visual allows you to use custom map regions. Instead of states or countries, you could use it to visualize different sales territories, store layouts, or specific zones that don't conform to standard geopolitical boundaries. It requires a specific file format (TopoJSON) to define your shapes, so it's a more advanced but highly flexible option.

For the rest of this guide, we'll focus primarily on the Azure Maps visual, as it offers the richest set of features for aesthetic improvement.

Essential Customizations in the Formatting Pane

Once you’ve selected the Azure Maps visual and added your data (e.g., city, state, postal code in the "Location" field), the magic happens in the "Format visual" pane. Let's break down the most impactful settings.

GraphedGraphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch Graphed demo video

1. Master Bubble Size and Scaling

The default bubbles on your map are probably all the same size. That's not very informative. You need to tie their size to a key performance indicator (KPI).

  • Drag a numeric field, like Sales or Number of Customers, into the "Size" data well in the Visualizations pane.
  • Now, navigate to Format visual > Bubbles. Here you can tweak the appearance.
  • Size: Adjust the slider to make all bubbles larger or smaller overall. Find a balance where the largest bubbles are prominent but don't completely obscure smaller ones.
  • Scaling: This is a powerful setting. Power BI defaults to a scaling method, but you can choose between Magnitude (size reflects the actual value, good for linear data) and Data Range (sizes are scaled between the min and max value in your dataset). Play with these to see which one best represents the variance in your data.
  • Transparency: Increasing transparency can help hugely if you have many overlapping data points in dense areas like a major city.

Pro Tip: Don’t just show where you have data, use size to immediately show how much data is there. The user’s eye should instantly be drawn to the biggest bubbles, which should represent your most important locations.

2. Use Color to Add Another Layer of Meaning

Color is the single most effective way to make a map more insightful. Instead of using a single color for all bubbles, use color to represent a second metric. For example, your bubble size could show total sales, while the bubble color shows profit margin.

To do this:

  1. Drag a second numeric field, like Profit Margin, into the "Legend" field on the Visualizations pane. Your bubbles will now be colored based on their profit margin category.
  2. To make this look much better, go to Format visual > Bubbles > Colors and click the fx button next to the color picker. This opens the conditional formatting window.
  3. Change the "Format style" to Gradient. Now you can set up a color scale. A classic choice is a "Diverging" scale. For example:

With this setup, anyone looking at the map can instantly spot a location that has big sales (a large bubble) but low profitability (a red bubble) — an insight that was completely hidden before.

3. Turn on Category Labels (Carefully)

Showing bubbles is a good start, but showing the name of the location being represented is even better. Navigate to Format visual > Category labels and toggle them on.

Be careful here, as this can easily clutter your map if you have hundreds of data points. Use these settings to keep it clean:

  • Adjust the font size and color for better readability against your map background.
  • Consider using the "Show background" option to place a slightly transparent box behind the text, making it stand out more.
  • If your map is too crowded, it’s often better to leave category labels off and rely on well-designed tooltips instead.
GraphedGraphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch Graphed demo video

Improve the Overall Look with Map Styles and Controls

Now let's zoom out from the data points and focus on the map itself. Azure Maps provides several themes that can dramatically change the context and feel of your visualization.

Choose an Effective Map Style

Under Format visual > Map settings > Style, you’ll find a dropdown menu of different base maps. Here’s how to use them effectively:

  • Road: The default view. It’s familiar and works for most general use cases.
  • Grayscale: A fantastic choice for business dashboards. Setting the map to grayscale or light gray makes your colored data bubbles pop off the screen. It removes distracting geographical features and directs all focus to your data.
  • Dark: If your Power BI report uses a dark theme, this is the obvious choice. It gives your dashboard a sleek, modern, and professional look.
  • Satellite/Aerial: Use this when the real-world physical location is important. For example, if you're plotting the locations of potential real estate investments or agricultural sites, seeing the actual terrain adds valuable context.

Fine-Tune Map Controls

Also under Map settings > Controls, you can define how users interact with your map. Giving them the right controls (or taking away unnecessary ones) can refine the experience.

  • Auto-zoom: By default, the map will try to zoom to fit all of the data points. You can turn this off if you want to set a fixed, default view for your users.
  • Zoom buttons: Adds the classic '+' and '-' buttons for zooming. Usually a good idea to leave these on.
  • Style picker: This adds a button to the map itself, allowing end-users to change the map style in the report view. This is great for dashboards where different users might want to see the data in different contexts (e.g., a logistics manager might want the road view, while a strategist might prefer satellite).

Advanced Techniques for a Professional Finish

If you've mastered the basics above, these advanced tips will take your maps to the next level.

1. Use Layers to Show Multiple Data Types

This is where Azure Maps truly shines. You can add multiple data representations onto a single map. Let's say you have store locations and customer home addresses.

  • Bubble Layer: Use a bubble layer to show your store locations, with size representing store revenue.
  • Heat Map Layer: Turn on the Heat map option in the formatting pane to visualize the density of customer addresses. This will create a colorful overlay showing where your customers are concentrated without having to plot every single address dot.

You can even add more advanced layers like a Bar Chart layer to show mini bar charts at each location, or a Reference Layer to add a file with supplementary boundary data.

GraphedGraphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch Graphed demo video

2. Customize Your Tooltips

A well-designed tooltip provides deep context without cluttering the map. The default tooltip just lists the fields you’ve used. But you can greatly enhance it:

  • Drag additional relevant-but-secondary fields into the "Tooltips" data well. For example, alongside Sales (size) and Profit Margin (color), you could add Average Order Value, Number of Transactions, or the Regional Manager's Name.
  • For the ultimate customization, create a separate report page formatted as a tooltip. This lets you design a pop-up window with multiple visuals — like a small line chart showing the sales trend for that location and a table of its top-selling products.

3. Manage Data Density and Clutter

The number one enemy of a good-looking map is clutter. If you have thousands of overlapping points, your viz will become a mess. Here’s how to handle it:

  • Use Slicers: Add slicers to your report page so users can filter the map by region, year, product category, etc. This empowers them to focus on the data that's relevant to them.
  • Leverage the Heat Map: As mentioned, a heat map is the best way to visualize areas of high concentration without having to render every single point.
  • Filter Your Data: In the Filters pane, consider filtering out data points that are not significant. For example, maybe you only want to show locations with sales over a certain threshold.

Final Thoughts

Creating an excellent Power BI map is about more than just plotting geographic points. It's about making conscious design choices - from selecting the right map visual and base layer to carefully using size, color, and labels to tell a clear and persuasive data story. By moving beyond the default settings, you can turn a basic map into the centerpiece of your report.

While mastering these settings in Power BI is a rewarding skill, we know it involves a lot of trial-and-error clicking through menus and watching tutorials. We designed Graphed to dramatically speed up this process. Instead of manually configuring every chart property, you can connect your data sources and simply ask for what you want in plain English, like "create a map of US stores, use sales for the bubble size and color them by profit margin on a green to red scale." Graphed generates the interactive visualization for you, helping you get to the insights in seconds, not hours.

Related Articles

How to Enable Data Analysis in Excel

Enable Excel's hidden data analysis tools with our step-by-step guide. Uncover trends, make forecasts, and turn raw numbers into actionable insights today!