Can we get the summarized data export columns in specific order?

[rajendraongole1]

Hi

I am exporting summarized data from bar chart. after export the data columns order is not coming in defined format/order.

Though i have changed the columns order at power query and backend in my sql server db.

any idea what was the logic for columns order defined at power bi services?

or is there any workaround to get the columns in specific order as per user request?

Regards,

Rajendra

[v-alq-msft]

Hi, @rajendraongole1 

Based on my tests, I assume that the exported column orders are related to the positions where fields are put. This type of export shows you only the data (columns and measures) that are being used to create the visual.

Test1:

Result1:

Test2:

Result2:

For further inforamtion, please refer Export the data that was used to create a visualization .

Best Regards

Allan

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

[amitchandak]

@rajendraongole1 , this has been already delivered. refer to the post

https://community.powerbi.com/t5/Issues/Export-data-column-order-wrong-for-xlsx-v-csv/idi-p/118758

https://community.powerbi.com/t5/Issues/Export-a-table-to-Excel-in-the-right-column-order/idi-p/1030...

[rajendraongole1]

Thanks @amitchandak .

Summarized/underlying data export column order is working only for Table/matrix.

Not with Line or bar charts.

is this possible with other visuals too? Please suggest.