How to create a map in Power BI

Do you know how to create a map in Power BI?

 

Maps are perhaps one of the most engaging visuals on any dashboard.  Creating a map in Power BI is a breeze.  Follow our step by step approach in the video or below to see how it’s done.

In a Power BI page, insert a Filled map visual:

How to create a map chart in Power BI - Step 1

In your recently created visual, drag and drop the fields Country, State and City to the Location section:

How to create a map chart in Power BI - Step 2

Now we have to add some numbers and change the colours.

Drag and drop the Gross Profit and Gross Profit Margin to the Tooltips section of the visual:

How to create a map chart in Power BI - Step 3

By the way, the Gross Profit and Gross Profit Margin formula are as below:
Gross Profit = CALCULATE(SUM(‘Actuals-Forecast'[Revenue])-SUM(‘Actuals-Forecast'[Expense]))

Gross Profit Margin = CALCULATE((SUM(‘Actuals-Forecast'[Revenue])-SUM(‘Actuals-Forecast'[Expense])) / SUM(‘Actuals-Forecast'[Revenue]))

Now we can change the colours and make them vary according to the Gross Profit Margin.
Go to the Format section of the map visual and then Data colors. Click on the “fx” button and on the new window, in the section “Based on field”, choose Gross Profit Margin, then you can change the default colours and hit OK.

How to create a map chart in Power BI - Step 4

As we’re in the Country level on the hierarchy, we’ll need to go down one level, so we can see the colour change:

How to create a map chart in Power BI - Step 5

And there you have it:

How to create a map chart in Power BI - Step 6

That’s how you create a map in Power BI.

For more helpful Power BI tips and guides, take a look at this:

How to guides for Power BI beginners