Forum Discussion

DmitriiZ's avatar
DmitriiZ
Frequent Visitor
5 years ago

How to handle multiselection in navigation table

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-custom-data/m-p/746611  , but I'm not sure if that solution would help with behavior of default navigation table view.

 

Need Help
Tutorial Requests

2 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    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's avatar
      DmitriiZ
      Frequent Visitor
      5 years ago

      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.