Possible to rearrange columns in a table?

[AlB]

Hi all,

Two questions:

1. Is it possible to move one column to another place in a table in Power BI? Imagine you have a table with many columns and you want to add a new calculated column. This gets added at the end of the table. It would be nice if it can be placed somewhere else, for example next to the columns used for calculating the new column.

Is that possible at all?

2. Is there any way to mark/highlight/color the calculated columns to that they can be readily differentiated from the original data columns (imported)

Thanks very much 

[Iden]

Another long winded way is to remake all your columns, copy the column definition, rename the orignal column as it doesnt like columns with the same name, create a new column, paste the original definition, delete the renamed original. its not ideal and long winded but its all ive found that can work whilst avoiding creating more tables.

[Greg_Deckler]

At the present time I am not aware of solution to either of those. For the first one, you could potentially create a new table based on the original table using SELECTCOLUMNS and put them in the order you want.

[AlB]

Thanks @Greg_Deckler

As to using SELECTCOLUMNS, if the table is large, with many columns, it would be quite time consuming wouldn't it?

[Greg_Deckler]

Oh yes, it's a terrible idea quite honestly, but technically a way to do it if you don't mind duplicating all of your data, increasing your data load times and creating a maintenance nightmare. 🙂

[AlB]

Sounds like a dream solution