Map Creation multiple cities

[RyanLMoran]

Hello:  We're creating a dashboard that will show various items.  One piece that we want to have is a map that will show the cities that we have computer labs in.  There are currently about 12 different cities.  Can somebody give me a bit of guidance as to the best way to structure this so that the 12 cities, currently all in one State but we may be adding additional States in the near future, will show on the map?  Thank you.

[RyanLMoran]

Thanks! I'm really just looking to dot the city in the respective State, rather than coloring a State.  Ideally, I'd have a dot for the 12 cities within the State.  Hover over the dot and it would give the city location.  Maybe a summary listing of all of the cities with the State that we have a presence in.  I'm just doing this as simply as possible off of an excel sheet and I'm not sure if I should have a separate sheet that lists the cities and their latitude and longitude or what is the best way to get these to show up as we want.  Thanks again.

[amitchandak]

@RyanLMoran , You can create a measure that shows if the city as compute lab

Cnt =Count(Table[Labs]) +0

If( [cnt] >0 , "green", "red")

Use this in conditional formatting using the field value option

https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...