Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |