US map with three data sets

[Klenmacnana]

I need to recreate a map that shows:

1. Number of employees per state

2. State performance. I have a list of each state's performance: 1 for high, 2 for medium, and 3 for low. 

My predecessor created a map that shows each state as either green, orange, or red for their performance, and the bubble for each state shows the number of employees. 

How can I recreate this in BI?

[Klenmacnana]

Hi Neeko, thank you for your reply! Is there a way to color the shapes themselves instead of the bubble? So, instead of the bubble of California being green, I want the entire state of California be green. 

[Anonymous · Accepted solution]

Hi @Klenmacnana ,

According to your description, you can create a filled map or a shape map.

Adjust the status color in the [Format your visual] pane.

Then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Anonymous]

Hi @Klenmacnana ,

According to your description, here are my steps you can follow as a solution.

1.Ensure you have a dataset that includes the following columns:
- State names (e.g., "California," "Texas," etc.)
- Number of employees per state
- State performance (high, medium, or low)
If you don't have latitude and longitude coordinates for each state, Power BI can automatically geo-code state names to create the map.

2. We can create a map visual.

3.Adjust the status color in the [Format your visual] pane.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.