Forum Discussion
US map with three data sets
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?
Hi Anonymous ,
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.
3 Replies
Hi Anonymous ,
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.
Hi Anonymous ,
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.