tampauf.blogg.se - Power bi gallery histogram

For this, go to Format and select Data Colors as shown below. Let’s start by changing the color allocated to the cities. Now we can format the data fields as per our need to make created Map look even better.

This completes the creation of Map in Power BI.

Bigger the size of the bubble, higher the quantities sold in that City.

As we do that, the size of the buddle there will get increased as per the size of data available in that region.

Then we will insert the quantities sold in the Size field section.

The color by which the city names are highlighted is in a default blue.

We will see the name of cities will get populated on the Map of India.

To start with first we will add the City Name into the Location field as shown below.

Size – This can be Population, Quantity or number which can be plotted on Map.

Longitude/ Latitude – This helps in finding the location on Bing Map.

Legend – This is like Location, here we can insert any data type by which we want to see the data in Map.

Location – It is the geographical location on the Map with the exact name there in Map.

Let’s see and understand available fields under Map.

Now from the Report section, select Map chart type from Visualization as shown below.

We will be able to see the data which we have uploaded there in the Data tab as shown below.

Also, we are renaming the Table name here as well from Sheet1 to Sales Data just to have proper sync.

Then we will see the uploaded data columns in the Field section as shown below. Here that sheet is Sheet1 and then click on Load. Now browse the file location and from the Navigator window select the Sheet which we want to upload.Here our data is in Excel so we will be selecting the same as shown below. For this, go to Get Data option from the Home menu ribbon and select the type of source we want. Let’s start by first uploading the data in Power BI.You can download this Power BI Maps Excel Template here – Power BI Maps Excel Template