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 (60)
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
RE: Allow selecting multiple columns in the data view
Cant select more than one column to format in Data Model, what a pain, Hope Microsoft fixes ir soon
RE: Allow selecting multiple columns in the data view
While you can manipulate multiple columns at once in the Edit Queries options, you can't select they unique type of date format, e.g. m/d/yyy in that view (at least not that I can figure out) and you must still adjust individual columns in data view.
RE: Allow selecting multiple columns in the data view
YOU CAN... You don't manipulate your columns in just Data View you do it in Edit Queries which is a tab on the Home Page of your Data View. If you use Hold Ctrl you can select multiple columns individually. If you use Hold Shift and click on the first and last column you want it will include all of them in-between.