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