Forum Discussion
filled and pin map
Hi there,
is there a way to combine filled map with exact pins for locations. Example:
I have crime rate for each country, and several locations (LAT and LONG).
I would like to dispal map where countries are filled with color on crime rate scale and on top of that my locations are bubbles or pins. to see how they are affected by crime rate. Is it possible to display it on one map? i cant seem to find the solution on my own..
4 Replies
- Greg_DecklerCommunity Champion
I am not aware of a way with the OOTB map visuals. ArcGIS map can almost certainly do it. Otherwise, there are loads of visuals in AppSource.
- AnonymousNot applicable
Create a filled map
From the Fields pane, select the Geo > State field.yellow check mark next to State
Convert the chart to a filled map. Notice that State is now in the Location well. Bing Maps uses the field in the Location well to create the map. The location can be a variety of valid locations: countries, states, counties, cities, zip codes, or other postal codes etc. Bing Maps provides filled map shapes for locations around the world. Without a valid entry in the Location well, Power BI cannot create the filled map.
templates with the icon for filled map highlighted
Filter the map to display only the continental United States.
a. To the left of the Visualizations pane, look for the Filters pane. Expand it if it is minimized
b. Hover over State and select the expand chevron
Visual level filters showing State(All)c. Place a check mark next to All and remove the check mark next to AK.
State dropdown with All and AK not selected
Select the paint roller icon to open the Formatting pane, and choose Data colors.
Formatting pane showing Data colors option
Select the three vertical dots and choose Conditional formatting.
Data colors conditional formatting button
Use the Default color - Data colors screen to determine how your filled map will be shaded. The options available to you include which field to base the shading, and how to apply the shading. In this example we're using the field SalesFact > Sentiment, and setting the lowest value for sentiment as orange and the highest value as blue. Values that fall between the maximum and minimum will be shades of orange and blue. The illustration at the bottom of the screen shows the range of colors that will be used.
Default color pane with Sentiment selected
The filled map is shaded in green and red, with red representing the lower sentiment numbers and green representing the higher, more-positive sentiment. To display additional detail, drag a field into the Tooltips well. Here we've added SalesFact > Sentiment gap. Highlighting the state of Idaho (ID) shows us that sentiment gap is low, at 6. filled map showing Idaho tooltips
Save the report.
MS Power BI gives you plenty of control over the appearance of your filled map. Play around with these data color controls until you get the look you want.
- AnonymousNot applicable
Thanks, but that is answer for a half of question. THe other half - is there a way to overlay the layer you described with set of specific locations with specific geocodes, e.g. London Bridge, Eiffel Tower...
- Greg_DecklerCommunity Champion
Anonymous - I have tried this with the out-of-the-box map visuals (not ArcGIS). I tried stacking the visuals on top of one another but cannot make the map background transparent.