Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |