Map Secondary Column on LINKTOFILTEREDVIEW() ...

(Kyle Grieb) #1

Map Secondary Column on LINKTOFILTEREDVIEW()

When using a map view with a secondary column and linking to that with filtered results via LINKTOFILTEREDVIEW(), the secondary column data is not present, assuming because the filter result does not contain the rows. How to include the secondary column data (additional optional filter) in the filter list? Tried ‘+TableA[Key]’

(Dinh Nguyen Nguyen) #2

@Buglouse I’m afraid I don’t quite understand the question. Are you having problem show the correct shows in the map view, or are you having problem show the correct columns when a certain pin in the map is selected?

If it’s the first case, you will need to review the filter expression. If it’s the second case, you will need to either check to see if the missing columns have any Show_If condition that is not met, or if the data source of the map view is a slice that does not contain the columns.

(Kyle Grieb) #3

The Secondary Column shows without the FilteredView, not in a FilteredView. No constraints on column definition. LINKTOFILTEREDVIEW(“Map”,in([ColA],TableA[Col])) Tried to append to list with +TableB[Col] and variations.

Does IN() result in Keys or Booleans…

(Dinh Nguyen Nguyen) #4

@Buglouse The IN() expression returns a boolean (yes/no) value. I’m afraid I still don’t understand what you’re trying to do. What is the “secondary column”? A map view should show no column, except for the pins, each of which is a row in the slice/table of the map view.