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.
This will also eliminate the use of Location Intelligence software as a counterpart when analyzing data.
Ryan Kozlowski commented
Is this feature still unavailable?
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
There should be a census tract layer so that you can join a worksheet and group by whatever you need. Seems simple.
My company also has custom sub-county areas we work with extensively. Currently such maps are made in ArcGIS
Fred Williams commented
I too would like to have this functionality (perhaps using BING Maps).
Solution: I have used the Synoptic Panel from OkViz to achieve the same (but with no map background).
Peter Johnson commented
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.
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
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.
I have been using this feature in Tableau and really miss it in PowerBI.
Daniil Maslyuk commented
How about Synoptic Designer by SQLBI? http://synoptic.design/
It would be important to determine sales territories
Jay Eckles commented
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.).
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
Having a way to create custom regions based on villages is something I have been looking for for the last two weeks.
Custom shape maps on a bing maps background would substantially boost the uptake of power bi in my workplace.
As someone who works with maps almost all the time, this would be a great way to save time with R and shapemaps.