Data view: I made a couple of calculated columns. They were added to the right, in the order column.
I then realized that a couple original columns (originally on the left) should be modeled as currency (they were just whole numbers).
This has moved those 2 columns to the far right, to the right of the calculated columns.
I see no way to return them to their original position, or to rearrange column order at all in Data View.....based on searching Q&A. But given there is a new release every month am wondering if this is still true?
Solved! Go to Solution.
It is unbelievable, if not unexpected. Microsoft has a long tradition of putting stuff out on the street before it's ready. Users have been complaining since the late '80s that paying customers have to be beta testers. A feature like this should have been a no-brainer for developers, and there is no excuse for its sitting in the ideas (bugs) queue for more than a day or two. What is the point of this exercise, if no action is ever taken by MS on these ideas?
I found a sollution. It is quite wierd, but it works.
Remove columns in Power Query view. save and apply changes. Then go back to power Query view, delete the removed Columns Steps in the desired order, and then your columns in Data view will be reordered.
Data view shows the last changed column last. That is the basic concept behind this trick.
Check out this link for more details:
It is extremely stupid way, but it is working - i found it by accident:
Hope it helped.
Haha! Good lateral thinking 🙂 I have just learned to live with it. The Power BI team keeps introducing brilliant new features so I can't complain much about the odd annoyance.
And now it is 2019 and I am still trying to associate values on one side of my data table to the other rather than having them nice and close which would make contextual sense.
oh my - - did see old Q&A on this topic - - just thought I would check.....
I will hazard the guess that Data View isn't perceived as important in that all the action is up in Visuals....but this lack of column rearrangement sure makes the initial modeling/transform more difficult to the BI designer first discovering the data set that we're working with......
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.