Filtering a map based on selected record

[JS00]

Hello,

I have a dataset that contains a column called date/time and some location data. I would like to add functionality so that the map only display points where the date falls into the selected range.

I created a disconnected duplicate table from the original table, and wrote some measures that allows users to click on a record in the disconnected table and my table visual will show the records/counts within 72 hours of the selected record. I would like to have the same functionality on my map - displaying the points within 72 hours of the selected record. Is there a way to do this? 

Thank you!

[Anonymous]

Hi @JS00 ,

According to your statement, I think your requirement is to only show the data in 72 within range baesed on selection in bubbles in map visual.

I think you can try this code to create a measure to control the size of the bubbles.

Bubble Size = 
VAR _SELECTDATE = SELECTEDVALUE(Selection[Date/time])
VAR _RANGESTART = _SELECTDATE - 3
RETURN
IF(MAX('Table'[Date/time]) >=_RANGESTART && MAX('Table'[Date/time])<=_SELECTDATE,1,0)

My Sample:

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JS00]

Thank you for the solution,

The map (arcgis) visual seems to work, but now my table are showing blanks and my other points on the map disappear whenever I click or select anything on the map.