Srinivasan Turuvekere on 22 Oct 2015 07:17:35
It would be great if you could select multiple columns in the data view e.g. the hide multiple columns from the report view in one operation.
- Comments (63)
RE: Allow selecting multiple columns in the data view
This thing is definitely needed.
RE: Allow selecting multiple columns in the data view
This is extremely annoying, it makes for a very inefficient formatting process and to make things worse every time I format something or change the type it takes me all the way back to column A.
RE: Allow selecting multiple columns in the data view
How do you select multiple columns for either pivoting or unpivoting in a query edit? I've seen the video for this and can not for my life get more than one column to be selected.
RE: Allow selecting multiple columns in the data view
Cannot format number columns to currencies in "edit queries" mode. I need to change multiple columns, not all next to each other, to different currencies, many at a time. I need to select columns H, I, AB, AF, BL etc. to change them to $, and then J, K, AC, AG, BM etc. to change them to Euro and so on. Super tedious to them one by one!
RE: Allow selecting multiple columns in the data view
And it is ridiculous that after changing one column's format, the view throws you back all the way to the left (back to column A) - so I have to scroll to the right again every time to go back an find the last column I formatted, because it loses the place where I was busy.
RE: Allow selecting multiple columns in the data view
Very handy for lot of things
RE: Allow selecting multiple columns in the data view
Workaround:
You can do this by keyboard in the relationships view: click on one item, then shift-arrow keys to select multiple. The context menu to hide columns also works when used from the keyboard (shift+F10 or context menu button) BUT as soon as you use the mouse (even to right-click), the selection will be lost.
RE: Allow selecting multiple columns in the data view
It's simple things like this that keep Power BI from being the platform of choice.
RE: Allow selecting multiple columns in the data view
Need this functionality badly as this is a basic need for big data warehouse
RE: Allow selecting multiple columns in the data view
very tedious to go through all columns and format decimals in data view