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
Solved! Go to Solution.
Yes, you may refer to pseudocode below.
Measure = IF ( [distance] <= [radius], 1 )
You may add two slicers and try creating a measure to calculate the distance, then drag it to Size of a Map visual.
Thanks @v-chuncz-msft - I thought the size in a map visual just changes the dot size - is that what you meant?
Yes, you may refer to pseudocode below.
Measure = IF ( [distance] <= [radius], 1 )
Thanks @v-chuncz-msft will try this out!
User | Count |
---|---|
126 | |
82 | |
77 | |
68 | |
67 |
User | Count |
---|---|
124 | |
74 | |
69 | |
59 | |
51 |