Forum Discussion

arimoldi's avatar
arimoldi
Resolver II
3 years ago

Filled Map with Region/City

Hi All,   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 fill...
Need Help
Tips and Tricks
arimoldi's avatar
arimoldi
Resolver II
3 years ago

Thanks for the hint!

 

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:

 

 

 Any suggestion? 🙂 

Sivakumar_H's avatar
Sivakumar_H
Helper I
3 years ago

arimoldi 
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:

 

Hierarchy:

 

 

 

  • arimoldi's avatar
    arimoldi
    Resolver II
    3 years ago

    Hi,

     

    at the moment the only way to figure it out is to use the hierarchy, even if is not user friendly to navigate the map since you have to expand the levels just for the countries that are splitted into regions/cities.

     

    Thanks,

    Andrea