Forum Discussion

palou0921's avatar
palou0921
New Member
10 years ago

Newbie Question

I have an Excel table listing customers. Among the columns are city, state, and country. (1) When I select state, a map comes up with a green dot in each state. I'm not seeing how to get the number ...
Need Help
MattAllington's avatar
MattAllington
Community Champion
10 years ago

In Power BI Desktop

  1. Go to the Data View
  2. Click on the City Column
  3. Go to the Modelling Menu
  4. Select Data Category = City
  5. Repeat for the other geographical columns

 

When you set up your Map, put a values field from your table in the Values section of the visualisation.  If you put population in the values section, you will get a bubble size based on population size etc.

  • palou0921's avatar
    palou0921
    New Member
    10 years ago

    Thanks Matt, I didn't know about the Modelling menu. I appreciate it.