How to handle multiselection in navigation table

[DmitriiZ]

Hi, 

I'm struggling with figuring out how to get the input from multi-selection in navigation table.

With, say, TripPin navigation table example (https://github.com/microsoft/DataConnectors/tree/master/samples/TripPin/3-NavTables) I would like to see 2 selected items side-by-side in the view, but can't find either anything like OnRowSelected/Deselected handler or a way how to get the multiple selected items into some function.

Desired functionality is working in AnalysisServices connector & by the look of the query - selected items are added as a functions to the result query

The closest thing I found to my question is that https://community.powerbi.com/t5/Developer/Select-Multiple-Drop-Down-Navigation-Table-Menu-for-custo...  , but I'm not sure if that solution would help with behavior of default navigation table view.

[v-jingzhang]

Hi @DmitriiZ  

What is the logic or rule to join multiple tables into one? Which values should be combined into the same row?

Regards,
Community Support Team _ Jing

[DmitriiZ]

Can be any rule, I can't find a way to get "selected" items on the left to build the view. 

In the end I'd like to have something like MSAS does - have some function which returns table based on selected measures & hierarchies.

For simplicity of this question, let's assume I want to add first row of airport to all the rows in airlines.