Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
i have customer data with postcode (example as below). I would like report find nearest customer based on another postcode or address data that i will put (just like google map which finds nearest location).
Hi @Yog ,
Unfortunately, at the moment, power bi does not have a function like Search Around. You can submit your ideas on power bi ideas.
Or You can add latitude and longitude coordinates to the customers and then create a measure for filter pane of this map visual.
measure is used to calculate the distance between two points and determine if they are within the distance you want, returning 1 if they are and blank if they are not. then in the filter pane, set it show itmes with no data.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |