Filled Map not working properly

[deepali_garg]

Hi All, 
I have a dim table with state , county and zip code in it.
When I am maping with Florida as a State and Washington as County., the map works properly and gives correct result whereas provides incorrect result for New Jersey for any county selected.

Data Category for State is State and County is County and Zipcode as Zipcode

Florida state data

For New Jersey, no data is populating.

Thank You, 
Deepali

[Greg_Deckler]

@deepali_garg Any chance you can share sample data to recreate this? As text.

[deepali_garg]

Hi @Greg_Deckler 

Sharing sample data 

state	cnty	zip_cd
Florida	Escambia	32505
Florida	Escambia	32577
Florida	Escambia	32507
Florida	Escambia	32523
Florida	Escambia	32533
Florida	Escambia	32503
Florida	Washington	36529
Florida	Washington	32420
Florida	Washington	32427
Florida	Washington	32431
Florida	Washington	32462
Florida	Washington	32463
Kentucky	Washington	40040
Kentucky	Washington	40061
Kentucky	Mercer	40078
New Jersey	Camden	8002
New Jersey	Camden	8003
New Jersey	Camden	8004
New Jersey	Camden	8007
New Jersey	Camden	8009
New Jersey	Camden	8018
New Jersey	Camden	8012
New Jersey	Camden	8021
New Jersey	Cumberland	8318
New Jersey	Cumberland	8320
New Jersey	Cumberland	8321
New Jersey	Cumberland	8323
New Jersey	Cumberland	8324
New Jersey	Cumberland	8327
New Jersey	Cumberland	8329
New Jersey	Cumberland	8332
New Jersey	Cumberland	8345

[Greg_Deckler]

@deepali_garg I could be mistaken but I'm betting the issue is that you need zero-padded zip codes like 08320. Could be an issue on import in that you need to override the default Change Type step in your query and instead of using numeric value go with Text, which will preserve the zero padding for your zip codes.

[deepali_garg]

Hi @Greg_Deckler ,

Zip code is saved in Text format only. Will this help or do i need to perform some other step.

[Greg_Deckler · Accepted solution]

@deepali_garg OK, well then the problem is in your data, it has truncated zip codes. So, one way to solve this would be to create a new DAX column like:

zip_code = FORMAT(INT([zip_cd]),"00000")

[deepali_garg]

Thank you @Greg_Deckler . This one helped me and resolved my issue. 

Have a great day !