Matrix to Table?

[huber57]

To whom: I have a list of people along with the state they live in. I would like to create a map with a bubble showing how many live in each state. My thought was to use a Matrix to count the number of each state listed. Can I then make that Matrix a table I can use for the map? Or, is there a better way to attack this problem? Any help is much appreciated! Doug

[amitchandak · Accepted solution]

You can also try conditional formatting

[v-yuta-msft · Accepted solution]

@huber57 ,

If you need to represent the location of each state, you should use bubble map, not matrix. However, if you only need to represent the total counts each state, you can create matrix visual using conditional formatting as mentioned above. It depends on your specific requirement.

Regards,

Jimmy Tao

[amitchandak · Accepted solution]

You can also try conditional formatting