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.
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
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.
@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
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.
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |