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:
In your recently created visual, drag and drop the fields Country, State and City to the Location section:
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:
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.
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:
And there you have it:
That’s how you create a map in Power BI.
For more helpful Power BI tips and guides, take a look at this: