Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

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 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , select with Ctrl and CLick.

     

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.

  • arock-well's avatar
    arock-well
    Icon for Responsive Resident rankResponsive Resident
    3 years ago

    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's avatar
      lbendlin
      Icon for Super User rankSuper User
      1 year ago
       but also the Shift key?

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

  • charade's avatar
    charade
    Regular Visitor
    1 year ago

    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?