Forum Discussion
mjfulke
9 years agoMicrosoft Employee
Create Your Own Custom Map for Power BI
Hi, I’m sharing back with community here (I encourage you to do the same as you come across your own useful Power BI tips and recipes) In this post, I will share how to create a custom map file t...
BManTN
9 years agoNew Member
Hi, thank you for the tip. I have searched, but cannot find if there is an easy way to create a custom map for sales districts and regions if those territories are mapped to specific counties or ZIP codes? For example, we divide the US into 5 regions and 21 districts. The districts are organized by counties (which may cross state borders). I have a simple Excel table that has county/state to district to region. How do you link the counties together to the district, and then the district to the region?
- mjfulke9 years agoMicrosoft EmployeeIn your example Region->District->County, I would suggest creating a map at the District level by drawing around the counties that make it up. Then use slicer for Region to select Regions (a collection of districts). As of today, shape maps don't support layer for a drill down type effect.