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

[MartinDrabek]

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

[JCABY]

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

[v-yuta-msft]

Hi MartinDrabek,

To export all data in a visual to excel or .csv file, please refer to:

https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-export-data.

Regards,

Jimmy Tao