Forum Discussion
How to display data in table with same column sorts from original excel
Hi, sometimes we need to load data from Excel which has lots of columns, and these columns has their own sequence, such as :
| A | C | D | E | F | G | T | R |
And when we load into Power BI Desktop and then want to display with a table, then we should tick the column one by one, and also need to care the sequence, that waste our time.
So I want to know if there any better way to load the data with same column sequence and can select all the column into a table of visualization？
2 Replies
- v-eachen-msft
Community Support
Hi Anonymous ,
Do you mean to automatically add fields to your visuals in the order they should be?
As far as I know, Power BI doesn't support it currently, you could come up a new idea about that here to improve Power BI and make this feature coming sooner.
