Forum Discussion

ManojG's avatar
ManojG
Frequent Visitor
5 years ago

Reordering columns when user export underlying data

I reordered the columns through Edit Query in power BI Desktop and published. But if export the underlying data, columns are appearing in earlier sequence. please help me in fixing this issue.
Need Help
ManojG's avatar
ManojG
Frequent Visitor
5 years ago

Hi,

I am using Pie and Column charts to repesent data in dashboard. When I export underlying data from Power BI Service, the coulmuns are all over the place. I want these columns to appear in certain order but it is not happening. I changed the sequence from Edit Query(Reorder columns) but in exported spreadsheet, sequnence doesn't change.

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi ManojG ,

 

Based on my test,  It is same in desktop. When I export data from pie chart, it shows as the order of the underlying data sources ignoring your sorting in the Query Editor. But when I export data from column chart or table visual, it works as I expected.

 

Please post this as an Issue using issues.powerbi.com.  first check to see if it has already been reported.   And  as a workaround ,if you want to export data as you expected, please first change it to column chart.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai