Select/Marking multiple rows/columns in visualization table like in Excel

[Anonymous]

Hi, 

to automatize a process, I want to visualize an excel table. I have tried the default "Table" from Power Bi. 

I want to change some settings on the table:

Users/Viewers should be able to mark more columns or rows just like in Excel: 

For example here I marked the A to C and 4 to 7 because I want to copy these Informations. This is flexible in Excel, You can mark whatever you want.

How can I make this possible in Power Bi? If I click on one clumn it only selects the whole column:

Is it possible to have same marking/copying options like in Excel?

Thanks in advantage 

[charade]

I would like something similar - My table has drill down which takes it to another page of data.  But if I select a couple of rows the drill down option disappears? 

[arock-well]

Closed/Solved topic, but when will Power BI allow to not only use the Ctrl key, but also the Shift key? For example, I'd like to select half of the results and don't want to click each row individually.

[lbendlin]

 but also the Shift key?

Rather stunningly, Power BI does not allow that at the moment. A major UI oversight.

[SanketBhagwat · Accepted solution]

Hi @Anonymous .

Yes, you can do that in Power BI.
Click on 'ctrl' button and select the rows which you want to highlight and copy.


Thanks,
Sanket.

If this post helps, then mark it as 'Accept as Answer' and give it a thumbs up.

[amitchandak]

@Anonymous , select with Ctrl and CLick.

I selected a few rows using CTRL and then Right Click and Copy Selection and pasted in excel