How to Create Power BI Pie Chart On Map?

This Power BI tutorial helps you work with the Power BI Pie Chart On Map.

In this short tutorial, I’ll show you how to create a Power BI pie chart on a map.

If you encounter the error “Map and filled map visuals aren’t enabled for your org. Contact your tenant admin to fix this.”, I will also guide you on how to solve it.

Power BI Pie Chart On Map

A Power BI Pie Chart On Map is a visual representation that combines a map with pie charts. It displays data as pie charts overlaid on specific locations, providing insight into the distribution of values across geographical areas.

Refer to the image below for how it looks:

How to create pie charts on world map

Create Power BI Pie Chart On Map

Now, we will see how to create a Power BI pie chart on a map.

Scenario:

Let’s say you own a chain of restaurants in different cities across the country. You want to visualize the distribution of sales by food category (such as Appetizers, Main Courses, and Desserts) in each city to identify which types of food are most popular in different regions.

In this scenario, using Power BI, we can create a Pie Chart on a map, where each slice of the pie represents a food category, and the size of the slice corresponds to the proportion of sales for that category in each city.

According to this scenario, we have a SharePoint list named City Food Sales Summary that contains the following columns with various data types:

ColumnsData Types
CityCity
LatitudeNumber
LongitudeNumber
Food CategorySingle line of text
SalesCurrency
Create a pie chart power bi report

Follow the below steps to create a Power BI pie chart on the map:

1. Open Power BI Desktop and load data using the Get data option. Then, we can see the data set in the Data Panel.

how to create a map in power bi

2. Under the Home tab, expand Visual gallery (black box) -> Click the Map visual.

Add a pie chart layer to Power BI map visual

3. If you face an Error: “Map and filled map visuals aren’t enabled for your org. Contact your tenant admin to fix this.” follow the steps below. If you do not face any errors, move directly to step 7.

Map and filled map visuals aren't enabled for your org. Contact your tenant admin to fix this in Power BI

4. To solve this error, go to File -> click Options and Settings -> Click Options. Check the screenshot below.

Create a map in Power BI

5. Now, you see the Options dialog box. Then click the Security option and check the Map and Filled Map visuals checkbox. Click on OK.

Create Pie chart on map power bi

6. After that, go to the Power BI Admin portal. You have enabled the “Map and filled map visuals.” Click on Apply; after 15 minutes, you can use it.

Solve Problem Map and Filled Map Visuals aren't Enabled

In this way, you can fix the map error in Power BI Desktop.

I hope you are not facing any errors or have solved the error now.

7. After that you can see one blank map visual added in the report view.

How to Creating a Map with Pie Chart in Power BI

8. Then, use the +Add data option to add City into Location, Food Category into Legend, and Sales into Bubble size.

Map with Pie Charts Power of Business Intelligence

9. You can now see the Power BI pie chart in the map visual.

How to Create Power BI Pie Chart On Map

This visualization helps you quickly understand the preferences of customers in different areas.

So this way, you can create a Power BI pie chart on the map visual.

Additionally, you may like some more Power BI tutorials: