Forum Discussion
Map visualization - appearance of selected items only
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
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
4 Replies
- amitchandak
Super User
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/
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
Community Champion
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?
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
