cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
huber57 Visitor
Visitor

Matrix to Table?

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
amitchandak Super Contributor
Super Contributor

Re: Matrix to Table?

You can also try conditional formatting

Screenshot 2019-09-30 22.46.12.png

View solution in original post

Community Support Team
Community Support Team

Re: Matrix to Table?

@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

View solution in original post

2 REPLIES 2
amitchandak Super Contributor
Super Contributor

Re: Matrix to Table?

You can also try conditional formatting

Screenshot 2019-09-30 22.46.12.png

View solution in original post

Community Support Team
Community Support Team

Re: Matrix to Table?

@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

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,762)