Forum Discussion

niteshtrehan89's avatar
niteshtrehan89
Icon for Helper III rankHelper 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 Farg...
Need Help
PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper 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
Icon for Helper III rankHelper 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.