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 )
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |