Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
Column sorting in query editor is possible and easy, just drag and drop columns to desired spots.
But that sort order will not be applied to the report view. The tables are alphabetically sorted in the report view, and the table columns are sorted alphabetically too.
By renaming tables or columns (prefix with some index or alphabet), you would be able to achieve the desired sorting. But thats a workaround.
Take a look at this:
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Thanks for your reply.
I am looking for Table/Column order change in data set, NOT the SORT Order in report.
I want to move the col3 to FIRST position in the table3. As well as Table4 to 1st position in the tables list.
Thanks in Advance.
Column sorting in query editor is possible and easy, just drag and drop columns to desired spots.
But that sort order will not be applied to the report view. The tables are alphabetically sorted in the report view, and the table columns are sorted alphabetically too.
By renaming tables or columns (prefix with some index or alphabet), you would be able to achieve the desired sorting. But thats a workaround.
Thanks Tarun. If we have any other work around other than Prefixing with some string, that will be great.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |