Forum Discussion

MartinDrabek's avatar
MartinDrabek
Regular Visitor
8 years ago

Select All Rows in Table to Display Detail in the Following Table

Dear PowerBI users,

 

I have the following challenge where I would like to ask you for an advice, please.

I have one data Query uploaded to PowerBI and have created 2 tables (I. and II.) with a different level of detail and filters (please reffer to the detailed picture). 

 

When I click on the row in the table I. I see detailed transactions in the table II. 

 

I would like to select all rows in the table I. in order to obtain all details in table II. (I need to export all data from table II to excel). I am able to select multiple rows from table I. using Ctrl+click, but I do not know how to select all lines from I.

 

Thank you very much for your advice. 

Martin

 

 

 

2 Replies

  • JCABY's avatar
    JCABY
    Frequent Visitor
    8 years ago

    Hi,

     

    I've got the same issue.

     

    I work on a SQL database. I have unique raws (ITSM tickets) with multiples actions and multiple answers in formulars.

    So I have 3 SQL tables.

     

    I need to list answers in tickets's formulars. But first of all I need to filter those tickets by their actions.

     

    I have table1 with actions, and table2 with answers. After filtered table1, I need to select all rows so it'll filter table2. And then, I can export datas from table2.

     

    As MartinDrabek, I also need an easiest way to select all rows of a table, like a "shift+click".