How can we improve Power BI?

let maps recognize data category hierarchy automatically

Currently maps don't seem to recognize the relationship between a country and a city, even if both columns have been set up with the corresponding data category in the model.

In a table with cities as "cities" and country as "country" in the data model, the cities are plotted in arbitrary countries instead of the country specified in the column for country.

Please let Power BI maps acknowledge the hierarchy of existing typed data categories and plot depending data points only in relation to their parent category context.

You may not feel the pain if you're in the US. I have a data set with cities all in New Zealand, but when I map them, they end up all over the globe, despite the "country" column specifying "NZ".

Please add your vote if you ever found a mapped dot outside of your desired country or continent.

160 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ingeborg HawighorstIngeborg Hawighorst shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    5 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • DickyDicky commented  ·   ·  Flag as inappropriate

        Agreed but even better would be to allow multiple fields to pin point the location so even if my country field isn't called country it can still be added along with Zip Code to pin point a location.

      • Andrew T.Andrew T. commented  ·   ·  Flag as inappropriate

        It's definitely an issue. Try mapping Birmingham, AL. You will find it in England. Similar examples exist. It's a little surprising when you can categorize the data as Location data.

      • Joop van den HeuvelJoop van den Heuvel commented  ·   ·  Flag as inappropriate

        Seriously, this is my number 1 issue with maps. Please fix this!

        Working from the Netherlands, it looks like Maps defaults to *every* other country in the world, before the map plots anything in the Netherlands: even the Dutch town of Breukelen sometimes gets plotted to Brooklyn, NY (which was named after Breukelen).

        The only work-around that fixes this is to *always* concatenate country with any other location data, like city/province/etc. as a single string in the same field (eg.: 'Breukelen, The Netherlands').

      • Dan EnglishDan English commented  ·   ·  Flag as inappropriate

        I would agree, particularly if you have defined a hierarchy for geography going from country->State->City->Zip Code then this should work. The context should be passed as you drill down into the data.

      Feedback and Knowledge Base

      Ready to get started?

      Try new features of Power BI today by signing up and learn more about our powerful suite of apps.