Sean on 24 Aug 2015 23:46:03
I'd like to be able to move/rearrange my Calculated Columns in the Data View so they can be placed next to columns where they would be more relevant and make more sense.
It would be nice also if the Calculated Columns are shaded darker as in PowerPivot so we can easily distinguish them.
Also please enable Ctrl+A (Select ALL) in the Data View - currently it works only in the Query Editor.
This way we could Select ALL Data in the Data View where it would include the Calculated Columns.
- Comments (90)
RE: Moving/Rearranging Calculated Columns
Surprisingly the move/select/rearrange of columns has not been solved after all the years of complaints by several users.
RE: Moving/Rearranging Calculated Columns
Re-arrranging columns in data view is good feature that MS PBI should be high priority.
RE: Moving/Rearranging Calculated Columns
Adding my vote for being able to rearrange calculated columns in the Table View. The functionality would be very beneficial for organizing data prior to report creation. While columns can be organized via PowerQuery or SELECTCOLUMNS DAX, both have limitations (no calculated columns in PQ, and SELECTCOLUMNS is time consuming and just creates another table, which can lead to performance issues, more maintenance, etc.). It's certainly fine to just create your "view" on the report side, but then you have to move back and forth between what you are calculating and what you are creating. Being able to streamline/organize reduces errors and improves the user experience. Is any logic based on column position within the table? I could see that being an issue, but it also seems odd if it was constructed in that manner. Anyways, first world problems, but I think the community (and certainly myself) would respond well to this improvement.
RE: Moving/Rearranging Calculated Columns
PLEASE FIX THIS!! THANK YOU... SUPER ANNOYING :-/
RE: Moving/Rearranging Calculated Columns
Just another voice to add how unbelievable it is that this very simple feature is not available! Imagine you had to leave your groceries in the order they were placed into the grocery bag to use them....
RE: Moving/Rearranging Calculated Columns
I love power BI, but i am infuriated by the amount of resurce sput into rever more fancy visuals when the basics of managing the data are ignored. it's rare I get exactyl the right column order on first shot and often its further into the project that additional columns have to be pulled in or calcuated. Now they are in a completely nonsensical order . Incredible we had this functionality in power pivot, but still being igonred
RE: Moving/Rearranging Calculated Columns
It's mindboggling that this is still not implemented, nine years later.Do you really need votes to make something the same as it is in Excel's implementation, in Power Pivot?
RE: Moving/Rearranging Calculated Columns
Adding my vote to enable moving calculated columns in the Table View to a logical order to the user/developer.
RE: Moving/Rearranging Calculated Columns
The column order should be maintained on the Data view as it appears in the Power Query. It is a pain to find the columns on this view when they are scrambled. This needs to be fixed.
RE: Moving/Rearranging Calculated Columns
Completely agree! Especially with arranging more complex models, the order of key columns is so important to help analyze the data model.Please add this feature!