Forum Discussion
Not able to select multiple columns in power query
Hi KR300
You can select multiple columns by holding the CTRL key on the keyboard and selecting the column you need or using the choose column features in Power Query.
Note: the green box is selected columns using CTRL key, the red box is unselected column.
If you find this helpful, kindly mark my response as a solution.
Regards,
Mubar
Hi KR300,
Thank you for reaching out to Microsoft Fabric Community.
As suggested by below super users can you please explain your issue in detail, so that we can provide you the best possible solution.
Thanks and regards,
Anjan Kumar Chippa
i have the same issue on my power query. if i select 1 column, hold down the Ctrl key or the ctrl+shift keys then try to select another column the first column i selected gets unselected and it selects only the second one. so ultimately i cant select more than 1 column at a time.
I have tried using the selct function which works when reducing removing some columns but when i am trying to Pivot or Unpivot i seem to not have a solution that works
Hi KR300,
As we haven’t heard back from you, we wanted to kindly follow up to check if your issue is resolved? or let us know if you need any further assistance.
If our response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa
v-achippa ronrsnfld Omid_Motamedise anmolmalviya05 , Apologies from my side.
I am not able to select multiple columns in power query. Even in the data view tab in desktop
Is there some reason you are not able to add screenshots and a better explanation?
Please show, in detail (with words and a screenshot), exactly what you are doing and the results of each step, otherwise from what you have written, the possibilities are too numerous to enumerate.
I am having the same issue in Power BI Version: 2.138.1004.0 32-bit (November 2024) that others have reported about not being able to multi-select columns in Power BI Power Query Editor.
From the Power BI Power Query Editor, I selected the column "Order Quantity" by clicking on it, and it is highlighted in green.
I then press on the Ctrl Key and click on the next column "Unit Price" . The Unit Price column is selected and highlighted in green, but the Order Quantity Column is no longer selected. I tried the same steps with Ctrl Shift but I am still unable to multi-select columns.
The solution to use the Choose Columns feature icon on the Home Page doesn't work because I am trying to use the Add column Standard feature to multiply the two columns, and to do this you need to multi-select the two columns.
