How can we improve Power BI?

Custom Territory for Power BI Map.

It should be possible to create a custom territory in Power BI. Not every Organization uses Continent, Country, State & Province or County for Mapping. Some Organizations want to create customer sales territories which is hugely valuable in getting granular into your Data.

Currently this feature is available in Tableau.
http://powertoolsfortableau.com/tools/drawing-tool

This will also eliminate the use of Location Intelligence software as a counterpart when analyzing data.

337 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Akan shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

16 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Dan commented  ·   ·  Flag as inappropriate

    I can't believe custom territories are not supported in Power BI, MS had this capability in the old Map Point program!

  • BRIAN TAM commented  ·   ·  Flag as inappropriate

    There should be a census tract layer so that you can join a worksheet and group by whatever you need. Seems simple.

  • Anonymous commented  ·   ·  Flag as inappropriate

    My company also has custom sub-county areas we work with extensively. Currently such maps are made in ArcGIS

  • Peter Johnson commented  ·   ·  Flag as inappropriate

    Yes, this would be incredibly useful. We've got Regions that break up into Districts that break up into Territories, and all of these can cut across state lines. A quick and easy way to display these on a map using zip codes and/or latitude/longitude would be ideal.

  • Patrick commented  ·   ·  Flag as inappropriate

    Could you extend the grouping feature to Geographical data? So you could group States, towns, zips, counties into larger contiguous or non-contiguous territories?

  • Dave Roberts commented  ·   ·  Flag as inappropriate

    This is possible if you've got a dedicated GIS program and use the shapemap visual. We've been using ArcGIS to create custom shapefiles for this purpose (by using the Dissolve tool), then using a website called Shape Escape to convert to TopoJSON and they're importing beautifully into Power BI Desktop. Tried converting using another website, and it wasn't playing nicely when imported - but I'm not affiliated to the website mentioned above either - it just works.

  • Jay Eckles commented  ·   ·  Flag as inappropriate

    If you can create a TopoJSON map with the territories, you can use the shapemap visual. For instance, we use shapemap and a custom topojson map to display student enrollment in state legislative districts (which cut right through counties, zip codes, area codes, etc.).

  • PatrickPilz commented  ·   ·  Flag as inappropriate

    Can't you use address information to define your territory, like zip-codes, states, counties or assign the territories to your customers directly in the dimension tables? Isn't this a true dimension that should come from your business application in the first place and not as a secondary layer in some BI reporting tool?

  • Wim Leys commented  ·   ·  Flag as inappropriate

    Having a way to create custom regions based on villages is something I have been looking for for the last two weeks.

  • dan commented  ·   ·  Flag as inappropriate

    Custom shape maps on a bing maps background would substantially boost the uptake of power bi in my workplace.

  • E commented  ·   ·  Flag as inappropriate

    As someone who works with maps almost all the time, this would be a great way to save time with R and shapemaps.

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.