Creating a filled map in Power BI is a great way to visualize geographical data. 

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

1. Prepare Your Data

Ensure your dataset includes geographical information such as country, state, city, or postal codes. For example:

| Country | State | City       | Value |

|---------|-------|------------|-------|

| India   | MH    | Sangli     | 100   |

| India   | MH    | Mumbai     | 200   |

| USA     | CA    | San Diego  | 150   |

2. Load Data into Power BI

Open Power BI Desktop.

Click on Home > Get Data > Excel (or the appropriate data source).

Select your file and load the data into Power BI.

3. Create the Filled Map

In the Visualizations pane, select the Filled Map icon (it looks like a map with shaded areas).

Drag the geographical fields (e.g., Country, State, City) to the Location well.

Drag the field you want to visualize (e.g., Value) to the Values well.

4. Customize the Map

Click on the map to select it.

In the Visualizations pane, you can customize the map's appearance:

Format: Adjust colors, borders, and labels.

Data Colors: Change the color scheme to better represent your data.

Title: Add a meaningful title to your map.

5. Interact with the Map

Use the map's interactive features to zoom in and out.

Hover over different regions to see detailed information.

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 Filled Map:

Here's how you would set it up:

Load the Data:

Import your data into Power BI.

Create the Filled Map:

Select the Filled Map from the "Visualizations" pane.

Add Fields:

1. To Get Profit according to States

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

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

2. To Get Profit According To Regions

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

Drag the "Region " field to the "Legend" 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 in Power BI that effectively displays your data.

Tip

You can also add "Sales" or "Profit"  to "Tooltip" to get more clarity from your data