Map Secondary Column on LINKTOFILTEREDVIEW() ...

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]โ€™

0 3 786
  • UX
3 REPLIES 3

Harry2
New Member

@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.

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โ€ฆ

Harry2
New Member

@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.

Top Labels in this Space