Auto-ordering columns in a table

[david2]

Hi all,

I have a table with 100+ columns that are randomly ordered. I would like to reorder the columns alphabetically, so it is easier to find a relevant column. I'd preferably automatic.

So instead of a table with columns E, C, B, D, A --> columns A, B, C, D, E.

Anyone know how to do this?

Thanks!

[Sean · Accepted solution]

If you are talking about rearranging columns in the Data View in PBI unfortunately you are out of luck

I posted this Idea (Aug 24, 2015)

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9467625-moving-rearranging-calcul...

For me it was more about the Calculated Columns because they all go to the end in order of creation

(in Power Pivot we could rearrnage them and place next to more relevant columns)

Hope they implement this someday!

[david2]

Yeah, that is what i'm talking about. Guess i have to do some manual reordering in this case. Thanks for the help!