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

 

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