How to Show Data Labels in Power BI Map
Showing data labels directly on a map in Power BI can sometimes feel like a hidden feature, but it's essential for creating reports that are easy to understand at a glance. Without them, your users are forced to hover over every single point just to see the underlying values. This article will guide you step-by-step through adding clear, readable data labels to your Power BI maps, focusing on the best visual to get the job done right.
Why Data Labels on Maps are so Important
Maps are fantastic for showing the "where" of your data, but their real power comes from showing the "what" and "how much" in that location. Imagine a map of the United States showing sales performance. Seeing bubbles of different sizes is helpful, but seeing the actual sales figures - like "$5M" over California and "$1.2M" over Texas - instantly provides context without any extra work from the viewer. Data labels turn your map from a pretty picture into a powerful analytical tool, enabling quicker insights and better decision-making.
The key challenge is that not all map visuals in Power BI handle labels in the same way. Let’s break down the options so you can choose the right one for your specific needs.
Understanding Power BI's Core Map Visuals
Power BI offers several built-in map options, each with its own strengths and weaknesses when it comes to labeling. Knowing which one to use is half the battle.
Map (Basic): This is the standard bubble map. It's great for showing magnitudes at specific geographic points (cities, addresses, etc.). However, its labeling capabilities are limited.
Filled Map (Choropleth): This map colors entire regions (states, countries, counties) based on a data value. It's excellent for showing regional patterns but generally doesn't support displaying numerical labels directly on the regions.
Azure Map: This is a more modern and highly versatile map visual. It offers superior performance and, most importantly, robust support for displaying and formatting both data and category labels. This is often your best bet for clear labeling.
ArcGIS Map: An enterprise-grade mapping visual from Esri that offers extensive layers, demographic data, and advanced cartographic styling, including powerful labeling features. It’s ideal for complex geospatial analysis.
Adding Labels to the Standard 'Map' Visual
Let's start with the most common map, the standard 'Map' visual. Many users get stuck here because the option to show numerical data labels isn’t obvious - because, unfortunately, it doesn't really exist in the way you'd expect.
Here’s how it works and what you can do:
Step 1: Create a Basic Bubble Map
First, create your map. Drag a geographic field like State or City into the Location field well, and a numeric measure like Sales into the Bubble size field. You'll see bubbles of varying sizes appear on the map.
Step 2: Turn on Category Labels
With the map visual selected, go to the Format visual pane (the paintbrush icon). Look for the Category labels section and switch the toggle to On.
This will display the name of the location (e.g., “California,” “New York”) next to or on each bubble. While useful, this is not the numerical data label we're after. This is where things get confusing for many users, as there is no corresponding "Data labels" toggle in this visual.
The Workaround: Embrace Tooltips
For the basic Map visual, Power BI intends for users to see detailed values through Tooltips. When you hover over a bubble, a small box appears showing the Location, Bubble size value, and anything else you’ve added to the Tooltips field well. This is the primary intended method for displaying values on this specific map type.
To improve your tooltips, you can drag additional measures into the Tooltips data field well to provide more context on hover.
The Best Solution: Using the 'Azure Map' Visual for Data Labels
If you want to display numerical values directly on your map, the Azure Map is the visual you should be using. It has the built-in functionality you're looking for and is more performant than the standard map.
Step 1: Enable the Azure Map Visual (If Needed)
The Azure Map visual should be enabled by default in recent versions of Power BI Desktop. If you don't see it in your Visualizations pane, you can enable it by going to File > Options and settings > Options > Preview features and making sure “Azure Map visual” is checked.
Step 2: Add Data to the Azure Map
Add the Azure Map visual to your report canvas. Drag your geographic data (e.g., State) to the Location field and your numeric measure (e.g., Profit) to the Size field. You now have a bubble map similar to the standard one.
Step 3: Enable Data Labels
This is the crucial step. With your Azure map selected, go to the Format visual pane.
Expand the Bubble layer section (or Bar chart layer, depending on your setup).
Scroll down and find an option titled Data labels.
Switch the toggle to On.
Instantly, the numerical values from your 'Size' field will appear on top of each bubble. Success!
Step 4: Format Your Data Labels for Readability
Just showing the numbers isn't enough, they need to be clear and easy to read. The Azure Map gives you excellent control over formatting within that same Data labels section.
Position: You can choose where the label appears relative to the bubble. Options like Center, Above, Below, etc., can help avoid overlap with bubble borders.
Text: Control the Font family, Font size, and Color. A high-contrast color (like white on dark blue) enhances readability.
Value: Format the number itself. You can set Display units (e.g., Thousands, Millions) to keep labels concise, and control the number of Value decimal places for precision.
Background: Turn on a background for the label, with a solid color behind the text, ensuring readability regardless of map background.
Displaying Labels on a 'Filled Map'
For Filled Maps, the story is similar to the standard Map visual. The primary method of showing data is through the intensity of the color fill, and detailed values are displayed via tooltips.
In the Format visual pane for a Filled Map, you will find a Category labels toggle. Turning this on will simply write the name of the region (e.g., "Texas," "Florida") on the map. It does not display the numerical value used to determine the color. For filled maps, relying on clear, informative tooltips is the best practice.
Tips for Effective Map Labeling
Once you’ve got your labels showing, follow these principles to keep your map clean and effective.
Avoid Clutter at All Costs: If you have many data points in a small area (e.g., all major cities in the Northeast US), turning on labels can make the map unreadable. The Azure Map can automatically hide labels at high zoom levels to reduce clutter. Use this feature strategically.
Context is King: Use the Display units option to make large numbers easier to digest (e.g., “$2.5M” instead of “$2,548,932.78”).
Lead with Contrast: Ensure labels are readable. Adjust font colors and backgrounds so labels stand out against map elements.
Combine with Other Visuals: Use maps as interactive filters for tables, bar charts, or other visuals. Clicking on a state can filter other visuals to show detailed data, creating a more effective dashboard.
Final Thoughts
While the standard Power BI Map visual is limited to category labels and tooltips, the Azure Map unlocks the full potential of your geospatial data by providing easy-to-use and highly customizable numerical data labels. Select the Azure Map and format your labels carefully for clarity and contrast to create reports that are visually appealing and instantly insightful.
Manually configuring reports in tools like Power BI is common but can be time-consuming. At Graphed, we’ve simplified this process so you can get quick insights—just ask, “Show me total profit by state on a map for last quarter”—and see the results immediately. Connect your data sources to Graphed to spend more time on decisions and less on report building.