Forum Discussion
Filled Map not working properly
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 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.
Hi Greg_Deckler ,
Zip code is saved in Text format only. Will this help or do i need to perform some other step.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")