Forum Discussion
Super UserIn Export data, By default some column order is coming
rajendraongole1
Unfortunately, you can not sort column when export data. The workaround is instead of apply sorting in your visual, you can do sorting in Query Editor and apply sorting for your data and brings it in your visual, then publish and update it to Service reports.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserAnonymous Paul Zhen,
I have tried reordering the columns in power query editor as per my requirement but still im not getting the order as expected it is coming in a way like calculated columns first next with some default order.
is that doable? can we set the reorder the column data for underlying dataset as per specific form?
Example: by default:
period_qq,country,customer,values1,value2,value3 value4
Expected result:
once i export the underlying data from chart
Value1,country,customer,period_qq,value3,value4,value2
Please suggest.
Hi Rajendra
Did you got any solution to the above sorting in underlying data issue? if yes please share the solution. I am also facing the same issue.
