Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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_Deckler's avatar
    Greg_Deckler
    Community 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.

  • Anonymous's avatar
    Anonymous
    Not 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.

    • Anonymous's avatar
      Anonymous
      Not 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_Deckler's avatar
        Greg_Deckler
        Community 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.