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
I cannot replicate your problem. I have the latest version and have no issues selecting multiple columns.
I want to transform/pivot columns, for which I need to select multiple columns. I used to do this by holding down the CTRL key and selecting the columns I need, but in the latest PBI version, I'm unable to do so. I'm not sure what the issue is, as I can still select multiple columns using the CTRL key in Excel, but not in Power BI. Can anyone please help me with this?