Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 c...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    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. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.