Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
dwel0120
Helper III
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  David Eldersveld, the map point size is a parameter for a variable distance threshold. With this parameter factoring into a size measure, it shows only points that fall within the user-selected maximum distance. All points the don’t meet the IF condition do not display on the map. When I take off the map point size under size the dots show up but then the distance slider won't work. 

 

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
dwel0120_0-1630678943599.png

 

 With map point size under size 

dwel0120_2-1630679006587.png

 

1 ACCEPTED SOLUTION
v-kelly-msft
Community Support
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

Did I answer your question? Mark my reply as a solution!

View solution in original post

5 REPLIES 5
v-kelly-msft
Community Support
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

Did I answer your question? Mark my reply as a solution!

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

dwel0120_0-1631026243934.png

 

 

Hi @dwel0120 ,

 

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

Remember to remove the confidential information.

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

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!

Hi @dwel0120 ,

 

Glad to help.🙂

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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