Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@Anonymous,
Yes, you may refer to pseudocode below.
Measure = IF ( [distance] <= [radius], 1 )
@Anonymous,
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?
@Anonymous,
Yes, you may refer to pseudocode below.
Measure = IF ( [distance] <= [radius], 1 )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
104 | |
104 | |
89 | |
66 |