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

[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.

[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