json county fill map, fips leading zeroes, text vs number format

[nyiballs]

Hi all.  First time posting a question.

I have a JSON map where I am trying to use fips to identify US Counties (County name is no good because of all of the duplicates, and even County Name - State isnt working).

When I use the fips as-is, they are formated as a number, which drops the leading zero and gives my blank states (below):

However... if I do a format([zip],"00000") it looks great, but it converts to text.  Ironically, the ones with the leading zeroes work, but the straight numerical ones disappear (below):

So... I'm at a loss... If I do text, I get my leading zeroes and nothing else.  If I do number, I get those, but not the leading zeroes.  

Would love to know if someone has experience with this and what workaround they have come up with...

Here's the map I used btw: https://eric.clst.org/tech/usgeojson/

[v-lionel-msft]

Hi @nyiballs ,

Did you set the data category to Postal zip?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

Generally at least in the default map visuals if you keep your zip code from being converted to numeric in Power Query and thus preserve the leading zeros and you flag that field as a Postal Code then it all works.