cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

## Dynamic Distance Map Help

I'm following the https://dataveld.com/2019/03/20/display-points-within-a-distance-radius-on-a-power-bi-map/ to create points within a distance radius on a simple pbi map. I have everything working except the Map Point Size is not working which then doesn't display any points on the map. Below is the map point size measure. Do I need to change something to get my points to show up on the map. According to

Map Point Size =
IF([Distance (mi)] <= [Maximum Distance (mi) Value],
IF(HASONEFILTER('Selector'[City]),
SWITCH(TRUE(),
[Distance (mi)] = 0,1,
0.25
),
1
),0)

Without the map point size

With map point size under size

1 ACCEPTED SOLUTION
Community Support

Hi  @dwel0120 ,

Try:

``````Map Point Size =
IF (
ISFILTERED ( 'Selector'[City] ),
IF (
[Distance (mi)] <= [Maximum Distance (mi) Value],
IF ( [Distance (mi)] = 0, 1, 0.25 ),
0
),
1
)
``````

Best Regards,
Kelly

5 REPLIES 5
Community Support

Hi  @dwel0120 ,

Try:

``````Map Point Size =
IF (
ISFILTERED ( 'Selector'[City] ),
IF (
[Distance (mi)] <= [Maximum Distance (mi) Value],
IF ( [Distance (mi)] = 0, 1, 0.25 ),
0
),
1
)
``````

Best Regards,
Kelly

Helper III

@v-kelly-msft That still didn't work. The points dissapear when I add the map point size to size.

Community Support

Hi @dwel0120 ，

Can you share me your .pbix file with some dummy data for test?

Remember to remove the confidential information.

Best Regards,
Kelly

Helper III

Your original code change worked!! I had switched the data source in one of the values I was tyring and forgot to switch back. Thank you so much!! I have been trying to figure this out for days. I really appreciate it!

Community Support

Hi @dwel0120 ，

Best Regards,
Kelly

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors