Forum Discussion
select multiple columns data view
Hi There - looking at a table on data view, I want to select multiple columns to unpivot. I don't know how to select multiple columns apparently; I've watched some youtube videos that have the multiple select action...they show: ctrl-shift & click more columns, ctrl-right arrow to highlight more columns. Those are simple but I'm not getting them to work on my power bi desktop app.
Has anyone solved this type of problem?
Jeff
jeffjenkins to unpivot, you have to go to query editor and that's where you will select column and unpivot the data.
4 Replies
jeffjenkins to unpivot, you have to go to query editor and that's where you will select column and unpivot the data.
Click Edit Queries-> Press on Ctrl, then select the columns using left-button of the mouse like below:
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thanks, that fixed me!
jeffjenkins glad to hear. Cheers!!
