Creating a map with a pie chart in Power BI Desktop is a fantastic way to visualize data. Here's how you can do it:

Step-by-Step Guide to Create a Filled Map in Power BI

1. Prepare Your Data: 

Ensure your dataset includes geographic fields (like city, state, country) and the data you want to visualize in the pie charts.

2. Open Power BI Desktop: 

Launch Power BI Desktop and load your dataset.

3. Create a Map Visual:

1. • In the Visualizations pane, select the map icon.

   • Drag your geographic data fields (e.g., city, state) to the Location well.

4. Add Pie Charts to the Map:

1. • In the Visualizations pane, select the "Filled Map" or "Map" visual.

   • Drag the field you want to visualize as a pie chart to the "Legend" section.

   • Drag the same field to the "Values" section to create the pie chart.

5. Customize Your Map:

1. • Use the Format pane to customize the appearance of your map and pie charts.

   • Adjust the map style, data colors, and other settings to suit your needs.

Example

Suppose you have a dataset with the following columns: Date, Sales, States, and Region. Here’s how you can display this data in a Map with Pie Chart:

Here's how you would set it up:

Load the Data:

Import your data into Power BI.

Create the Map:

Select the Map from the "Visualizations" pane.

Add Fields:

Drag the "State" field to the "Location" area.

Drag the "Profit " field to the "Legend" area.

To Get Profit According To Regions

Drag the "State" field to the "Location" area.

Drag the "Category " field to the "Legend" area.

Drag the "Sales " OR "Category" field to the "Bubble Size" area.

Customize:

Use the "Format" pane to adjust the Map appearance.

Customize the appearance as needed using the Format pane.

Your Map should now display the data points in a clear and organized manner.

By following these steps, you should be able to create a Map with Pie Chart in Power BI that effectively displays your data.