Forum Discussion
Filled Map not working properly
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
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")
6 Replies
deepali_garg Any chance you can share sample data to recreate this? As text.
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 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.
