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

Map Visualization Legend Measure

Hi guys, it is a pleasure to greet you.

I really need your help with a problem that I am facing currently. I am using a map visualization to show the average risk in some places. However, when I add the specific column on the legend option, on the map appears a pie chart. However, I don´t really need the pie, I just need a circle that shows me the risk average. It would be easy to use a measure, but map visualization doesn’t allow measures on the legend field.

Anyone can help me please with this situation?

Thanks in advance.

 

PLACERISK LEVELYEAR
Quito, Ecuador32019
Santiago Chile52017
Quito, Ecuador202019
Galapagos, Ecuador302018
Santa Cruz, Bolivia302017
Galapagos, Ecuador1002017
Santiago Chile1002017
Galapagos, Ecuador1002019
Quito, Ecuador1002018
Santa Cruz, Bolivia302017
Santa Cruz, Bolivia52017
Galapagos, Ecuador182018

 

 

Captura.PNG

In the picture, you can see that appears a pie chart, but i reallyu need the average RISK. By the way, the map must be updated when I change the filters on the sheet. 

3 REPLIES 3
Community Support Team
Community Support Team

Re: Map Visualization Legend Measure

Hi @eorjuelad ,

According to your description, my understanding is that you want to display the average of RISK LEVEL for each PLACE, in this scenario, we can drag the RISK LEVEL column to the size field, and select the Average like below:

PBIDesktop_BZxZaA48Za.png

The result will like below:

PBIDesktop_YlGwFFH3WO.png

Best Regards,

Teige

eorjuelad Frequent Visitor
Frequent Visitor

Re: Map Visualization Legend Measure

Hi @TeigeGao.

 

Thanks for your answer. However, I didn´t mention before that I am using another information on size field that show me how many times, I have checked the RISK LEVEL in a specific place. The idea to use the RISK LEVEL on Legend Field is because I need to give a specific color to the bubble depending on the RISK LEVEL. By the way, you helped me to realize that I don´t need the average calculation, I really need the Median Calculation.

Captura.PNG

The size will be changed depending on how many times I have checked the place.

The color will be changed depending on the risk level Median

Thanks in advance.

Eder.

Highlighted
eorjuelad Frequent Visitor
Frequent Visitor

Re: Map Visualization Legend Measure

Hi everybody, 

 

Please someone who can help me with this post. Although I Have tried to get a solution, I haven´t been able to do it.

@TeigeGao  has given me a solution that could works, but the scenery that I have is completely different.

 

Thanks in advance.

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 (4,490)