Forum Discussion

dwel0120's avatar
dwel0120
Helper III
4 years ago
Solved

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

 

 With map point size under size 

 

  • 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!

5 Replies

  • v-kelly-msft's avatar
    v-kelly-msft
    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!

    • dwel0120's avatar
      dwel0120
      Helper III

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

       

       
      • v-kelly-msft's avatar
        v-kelly-msft
        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

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