Map visualization - appearance of selected items only

[Anonymous]

Dear Community,

I have ~2000 location points on a map visualization (quite a mess), which are relating to transport routes. In the same time I also have a table of transport route data.

Is it possible, that only those location points are visible, which are seleted on the table (e.g. click on transport route ID)? This would mean that the map would appear as empty at the beginning.

Thank you for your help in advance!

Peter

[Anonymous · Accepted solution]

Hi @Anonymous ,

Make sure there's no active relationship between these two tables.

Then create a measure as below.

Measure = IF(ISFILTERED('Table 2'[location]),IF(SELECTEDVALUE('Table'[location]) in VALUES('Table 2'[location]),1,0),0)

And add this measure to the visual level filter.

Result would be shown as below.

 

Best Regards,

Jay

[amitchandak]

@Anonymous , you can try with is filtered or has one value

Check video for reference

A new measure like this https://www.youtube.com/watch?v=hXg3kRFSGjA

if(isfiltered(Table[route]) , [Measure], blank())

refer: https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[Anonymous]

Hi @amitchandak ,

we are close with the isfiltered function! 🙂

In your suggested formula if(isfiltered(Table[route]) , [Measure], blank() --> what kind of measure can provide multiple rows of the location ID column as result?

In my use case it is important, because for a selected transport route at least 2 (pick-up and delviery) locations are relating.

Thank you very much in advance!

Peter

[AllisonKennedy]

@Anonymous  How many items do you want them to be able to select in the table? This should work by default except for the part about the map being empty at the beginning. You may just need to Edit Interactions and set the map to Filter when a table row/item is selected. 

Getting it empty at the beginning can be done with a measure, but then you need to define how many points can be selected and still not have an empty map - all but one? just one?