Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Mapping question

Hi all,

 

I'm delving into mapping on Power BI and loving it so far. I have a number of addresses for companies that I produce ratings for and would like to know if its possible to have an input box, where a user can enter an address or city, then have another input box to enter a radius. I'd like these 2 inputs to run a query which shows the user the companies in that radius or even square area.

 

Is this possible with Power BI using in-built or even custom visualisations?

 

 

thank you

  • Anonymous,

     

    Yes, you may refer to pseudocode below.

    Measure =
    IF ( [distance] <= [radius], 1 )
    

4 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support

    Anonymous,

     

    You may add two slicers and try creating a measure to calculate the distance, then drag it to Size of a Map visual.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks v-chuncz-msft - I thought the size in a map visual just changes the dot size - is that what you meant?

      • v-chuncz-msft's avatar
        v-chuncz-msft
        Community Support

        Anonymous,

         

        Yes, you may refer to pseudocode below.

        Measure =
        IF ( [distance] <= [radius], 1 )