Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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