Well said by Jim Rohn. Today, I’ll look at at how to format a filled map (Choropleth) in Power BI.

Power BI Desktop Version

I’m using version 2.76.5…. released ~ 12/18/2019. There are no newer updates as of 2/15/2020. If you are using a different version, your results may vary.

Report Window

From the Data Window click on the Report icon on the left. This will stitch the view from the Data Window to the Report Window and expose the Visualization Pane

Create The Filled Map

Click on the Filled Map Visualization Icon in the Visualization Pane. The Filled Map Visualization will appear on the Report Canvas.

Click on the Filled Map on the Report Canvas. This will expose the Location Fields at the bottom of the Visualization Pane. Once the fields are exposed, drag the State Field from the Data Pane to Location. Lastly drag the Pcnt Change Field from the Data Pane to Tooltips in the Data Fieelds at the bottom of the Visualization Pane.

You should now have a filled map that looks something like the image below.

Conditional Formatting

Now I need to add divergent colors to the filled map so I can quickly see which states have the greatest percentage change in population from 2010 to 2019.

  1. Click on the Filled Map on the Report Canvas
  2. Click on the Format Button Below the Icons in the Visualization Pane
  3. Click on the drop-down for Data colors
  4. When you mouse over Default Color notice that a vertical elipses is visible
  5. Click on the vertical elipses
  6. Click on the fx Conditional Formatting pop-up

The Default Color – Data color dialog opens. The State is the default field for Based On Field – click on the drop-down and change to Pcnt Change.

Change the Colors for Minimum and Maximum to 2 different contrasting colors. I’ll use a very light grey and black.

Interpret the Visualization

Even at this small zoom level, it is easy to see some differences in population increases and decreases. It appears as though West Virginia, Illinois and Mississippi had negative to very low population increase. On the other hand; Nevada, Texas and Utah had large population increases.

The only one I found surprising was Utah at 16% increase from 2010 to 2019. I had heard of all of the others through social media and or news outlets over the past few years.

Divergent Color

You can add a 3rd color to the Conditional Formatting if you so choose. Tick the checkbox for Diverging and you will receive a middle value input for the middle color as well.

Custom Color – HEX Only, No RGB

I come from Excel where I am used to using RGB (Red, Green, Blue) values for creating custom colors. RGB is not an option in the Default Color Dialog – you have to use hexadecimal values.

Hexadecimal Resources

I found a good resource for working with hexadecimal colors at color-hex. Make sure you check it out.

Tidy up

That’s it for today. Grab the workbook from my OneDrive. Post inspired by this post at PowerBI tips by Mark Carlo and Seth Bauer.

, , , , , , , ,

no comment untill now

Add your comment now