Forum Discussion

deepali_garg's avatar
deepali_garg
Frequent Visitor
4 years ago
Solved

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 provi...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    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's avatar
deepali_garg
Frequent Visitor
4 years ago

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's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

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's avatar
    deepali_garg
    Frequent Visitor
    4 years ago

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

    Have a great day !