Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Navigate to the other table

Dear All, 

 

Is there a way in power bi to add a link to a table column to navigate to the another table. 

 

For example I have Sales and Order tables. Below shows my Sales table.

 

 

I need to add a link to material column in Sales table, so that when selected a material from the column, it navigate to the Order table. Below shows my Order table. 

 

 

Can some one help me. 

 

Thank you.

SRHerath.

  • MFelix's avatar
    MFelix
    3 years ago

    On the Table View no, you can have on the report a way to do that using drill trough, but the model view the tables are independent.

4 Replies

  • Hi Anonymous ,

     

    When you refer a link to another table, to navigate, do you mean like in excel where we can go to another sheet double clicking a cell with a formula?

     

    You cannot navigate from table to table within the Table View by clicking on a column you need to use the data pane.

     

    Can you elaborate a little bit more on your request please.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Dear MFelix ,

       

      Yes, As you said I need to navigate to the other table when click on a table cell as in excel. Is there a way to do it?

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User

        On the Table View no, you can have on the report a way to do that using drill trough, but the model view the tables are independent.