Forum Discussion

nsundararajan's avatar
nsundararajan
Helper I
10 years ago

Fill Map Visualization (Puerto Rico )

Can some one help me, we have states, region combined in one of the column which has Continental US states and PR. When I select the Field and use it as Location in the Fill Map and change it  (State...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

This is probably not the issue, but hopefully in your data it is "Puerto Rico" and not "Pueto Rico". You will likely have more luck with this question on the Bing Maps forums because Power BI uses Bing Maps for geocoding.

nsundararajan's avatar
nsundararajan
Helper I
10 years ago

Sorry for the spelling Mistake. It's Puerto Rico and the value we have is PR.

  • Sean's avatar
    Sean
    Community Champion
    10 years ago

    nsundararajan Seem you have to categorize it as country

    Look at the pictures - shows as country not as state

    EDIT: Try concatenating State, Country

     

    • Sean's avatar
      Sean
      Community Champion
      10 years ago

      nsundararajan Yes concatenation works as expected - but leave it Uncategorized

      (this will mess up your legend though because it will be based on country now - don't know if it matters in your case)

      • nsundararajan's avatar
        nsundararajan
        Helper I
        10 years ago

        If I do Country Region, then States like FL, TX won't work. My Requirements is we have Regions like FL , TX, GA , PR. 

        I want all work together. If I select Country, Region then FL, TX, GA won't work. If I select State, Province PR is not working.