filled and pin map

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.