Forum Discussion

dwel0120's avatar
dwel0120
Icon for Helper III rankHelper III
5 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 e...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    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's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
5 years ago

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
    Icon for Helper III rankHelper III
    5 years ago

    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
      Icon for Community Support rankCommunity Support
      5 years ago

      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!

      • dwel0120's avatar
        dwel0120
        Icon for Helper III rankHelper III
        5 years ago

        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!