Forum Discussion

hamachekm's avatar
hamachekm
Icon for Helper I rankHelper I
5 years ago

Map shows Selected and All Addresses with different Size

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

 

Need Help

3 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    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
     
    • hamachekm's avatar
      hamachekm
      Icon for Helper I rankHelper I
      5 years ago

      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?
  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    5 years ago

    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.