Forum Discussion

grkanth81's avatar
grkanth81
Icon for Helper II rankHelper II
9 years ago
Solved

Power Bi Maps Australia

Hello guys,   I am trying to create a power BI map report where i would like to know number of employees by state, by city, by suburb.   When you click on particular state, it has to take to show...
Need Help
  • deldersveld's avatar
    deldersveld
    9 years ago

    Try creating a derived column to combine the suburb, city, and country in either Power Query or DAX. I'm assuming you've already petitioned all local governments to change rename everything to be globally unique, and that's been denied :-)

     

    Using DAX: Suburb_Derived = Sheet2[Suburb] & ", " & Sheet2[City] & ", " & Sheet2[Country]

     

     

  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi grkanth81,

     

    Because there might existing same suburb name in different countries. That is why under suburb level, the map visual shows details of other countries also.

     

    In order to uniquely identify suburb across the world, I would suggest you use PostCode. Please see below:

     

    Best regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi grkanth81,

 

Because there might existing same suburb name in different countries. That is why under suburb level, the map visual shows details of other countries also.

 

In order to uniquely identify suburb across the world, I would suggest you use PostCode. Please see below:

 

Best regards,
Yuliana Gu

  • grkanth81's avatar
    grkanth81
    Icon for Helper II rankHelper II
    9 years ago

    Thanks v-yulgu-msft. That worked using post code option also.