Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Experts,
I think the answer is essentially no, but is there a way to rearrange the columns in table view, specifically calculated columns?
Example:
I'd like to move the 'Total Fee Rate' next to the 'Fee Fixed Rate'. I cannot do so in Power Query as it is a calculated column. Also, I don't want to use the SELECTCOLUMNS function and reorder that way, since, well, its time consuming and I've created a whole other table (data size, maintennace, etc.).
Is there a workaround? And if not, could someone explain the difficulty to implementing?
Thanks!
Solved! Go to Solution.
There is no real way to re-order the column, but there is an idea you can upvote - https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=a272113a-0f44-41ac-a402-bf1066984cda
There might be a work-around by removing your columns in PowerQuery, loading and re-loading data. Check the second solution here: https://stackoverflow.com/questions/54354205/trying-to-reorder-columns-in-data-view-in-power-bi
Thanks @vicky_ ! I have added my vote.
And I saw that Stack post. The issue is that calculated columns still wouldn't display in PowerQuery, so while that is a nifty way to reorganize your data, I don't think its applicable everywhere. I appreciate it though, just seems it's a blood from rock scenario (nigh impossible).
There is no real way to re-order the column, but there is an idea you can upvote - https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=a272113a-0f44-41ac-a402-bf1066984cda
There might be a work-around by removing your columns in PowerQuery, loading and re-loading data. Check the second solution here: https://stackoverflow.com/questions/54354205/trying-to-reorder-columns-in-data-view-in-power-bi
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |