Filled Map with Region/City

Question

Hi All,&nbsp;I have a filled map with a list of countries and a related measure, the problem is that for a specific region I have the values splitted by cities, and I should show this view in the filled map.&nbsp;Example of data set:In this example I should show the Italy country splitted into 2 parts, for example one north part related to Milan and one south part related to Rome.&nbsp;Isi it possible? Any suggestions?&nbsp;Thanks,Andrea&nbsp;&nbsp;

sivakumar_h · Answer

Hi&nbsp;arimoldi&nbsp;You are on right path!But you have to make a column datatype as State or Province.The Sample Dataset you have highlighted two different region in Italy, If you want whole area should be shaded then you have to mention that too like Italy - xx, Italy - xxx, Italy - xxxx and Italy - yy, Italy - yyy, Italy - yyyy etc.,&nbsp;

sivakumar_h · Answer

arimoldi&nbsp;There is no straight forward!You can achieve both Country and City values in adjacent filled map which cross filter through one map to another, As far as I seen PBI doesn't show hierarchy in a single filled map, But you can also drill down to split the values.Cross Filter:&nbsp;Hierarchy:&nbsp;&nbsp;&nbsp;

amitchandak · Answer

arimoldi , I doubt that is possible in filled map, unless you have separate location and have map at location level

arimoldi · Answer

Thanks for the reply!&nbsp;The idea is to have something like this (ie italy):&nbsp;&nbsp;Any idea?&nbsp;Thanks,Andrea&nbsp;

arimoldi · Answer

Thanks for the hint!&nbsp;With the "City" categorization the map recognized correctly the two cities, but now I have to undertstand how to show in the same map both cities and countries; I have tried to put both in the Location, but it shows only the top one:&nbsp;&nbsp;&nbsp;Any suggestion? 🙂&nbsp;

Forum Discussion

Filled Map with Region/City

6 Replies

Related content

Regions and Cities on the Azure Map

Filled map

City/region formatting

Consolidating Cities into Regions

Creating Regions from a Group of Cities