Filled map and/or choropleth - States and counties

[Louis66]

Hello,

I have slicer 1 : U.S. States

I have slicer 2 : U.S. Counties

Selecting, for example, Idaho works fine... Idaho & all counties of Idaho appear. The problem is, the county of Washington (Idaho) obviously shows in Idaho (whether or not I do select it on slicer 2) AND in other U.S. States as well.

So I need to create something that will make sure that all counties in Idaho will show up once (in Idaho only).

Thanks for your help...

Louis

[PhilipTreacy · Accepted solution]

Hi @Louis66 

Download example PBIX file 

try adding a column that contains County,State e.g. Bannock,Idaho

Mark that column as County and add this column to the Location well for the map.

Regards

Phil

[kec788]

Hello - how are you showing the map by county boundaries? I'm trying to replicate the same thing, but the closest I've gotten is with Filled Map which has some other unnecessary stuff. Thanks in advance!

[PhilipTreacy · Accepted solution]

Hi @Louis66 

Download example PBIX file 

try adding a column that contains County,State e.g. Bannock,Idaho

Mark that column as County and add this column to the Location well for the map.

Regards

Phil

[CP4]

Hi Louis,  Could you please teach me how to show the USA Map by counties?Thanks. I only fund the fill map by state.

[kec788]

I'd like to know this as well!

[bbbbi01]

Hi! Is it possible to drill down from county level to cities and zip codes? Thanks!

[Louis66 · Accepted solution]

Great !

It works perfectly !

Louis