Forum Discussion

niteshtrehan89's avatar
niteshtrehan89
Helper III
5 years ago

Filled Map

Hi All, 

 

There is an urgent requirement where i have city data and I need to fill the state in the filled map.

 

dataset :-

 

City                       Sales

Minneapolis          1000

Fargo                     2000

Houston                1000

 

So I need the below states to be get filled in filled map.

Minnesota, North Dakota and Taxes

Need Help

3 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    Hi niteshtrehan89 

     

    Download example PBIX file

     

    The Filled map won't do this.  You can use the Shape map to fill the state but you will need to add another column in your table for the State.

    State = IF('Table'[City] = "Fargo", "North Dakota", IF ('Table'[City] = "Houston", "Texas", "Minnesota"))

    The Legend can show the City.

    Regards

    Phil

     

    • niteshtrehan89's avatar
      niteshtrehan89
      Helper III
      5 years ago

      Hi PhilipTreacy 

      Thanks for the solution. We don't have the state data in the dataset, from the city data we need to fill the state.

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    Hi niteshtrehan89 

     

    Download example PBIX file

     

    OK so what cities have you got in your list?  You can either add a column for the state in the way I've demonstrated, or you can get/create a table of City/State and then do a merge (in Power Query) to bring that state into your main data table used for the map.  See PBIX file above for an example of this.

    Regards

    Phil