Map shows Selected and All Addresses with different Size

[hamachekm]

Hello,

I would like to make a 'Map' visual. 

Location = Street Address of Business

Size = If Business is "Selected" with a Slicer, then make it big dot on map. If not "Selected", then make it small dot. 

The end user will need to be able to toggle the Slicer to modify the selected businesses, so this cannot be a calcualated column. 

Can this be done? If so, how?

Thanks,

Mike

[v-yingjl]

Hi @hamachekm ,

As far as I know, currently the bubble size is controlled by the format pane manually, put the measure in the Size field could not affect the bubble size.

Perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner: https://ideas.powerbi.com/forums/265200-power-bi-ideas

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[selimovd]

Hey @hamachekm ,

this could actually work.

Use a map visual and create a measure for the size of the dot.

Then you can check if the value is selected with SELECTEDVALUE and give back a different value for the size.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[hamachekm]

Thanks Denis,

Using SelectedValue allows all dots to show. But the size is not being adjusted. I have this measure in the "Size" property:     

Selected Map Size = if(selectedvalue(Business[Business]), 100, 5)

Is there one more step to get the size difference to apply on the map?