Forum Discussion
create territories in Power BI Maps
Thank you for your response.
My data looks like so using Map visualization:
| State | Sales Rep |
| Illinois | Billy H |
| Ohio | Billy H |
| Michigan | Billy H |
| Connecticut | Brian E |
| New Jersey | Jeremy K |
| New York | Brian E |
| Texas | John Q |
| Alabama | Jeremy K |
| Indiana | Jeremy K |
| Louisiana | Jeremy K |
| Mississippi | Billy H |
Resolver IIs this what you're looking for?
Yes this looks like what I'm looking for. How Do I get it that way in Power BI? The intent is to have it look like this (created with Powerview in Excel);
When i do this in power BI it like this for me. See how it puts all the sales reps in every state?
- Greg_Deckler
Community Champion
This is going to sound weird, but add a custom column like:
Column = 1
Add that to Size in map properties and you will have what you want.
You could also add "Sales Rep" to Size and it will change to "Count of Sales Rep" and do the same thing.
- a_mixed_life
If that's the case, you can always place the "Salesperson" under the Tooltip however it won't do you much but provide a count unless you use Zip Code or City on your data (See screenshot), that will help as well. That's how mines is setup.
