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.
Hello, very new to power bi.
I have a single-column table I have generated using power bi desktop from scraping a webpage.
The data has the order that came from the webpage and is important
When I use "Analyze in Excel" the data gets sorted automatically in Excel in descending order
How to prevent this? I need the original order preserved!
Thanks
Solved! Go to Solution.
Hi @Anonymous ,
You can add an index column in Power Query when you transform the data.
Export the data after sorting this table or visual by index.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I did not see there was a responce. Thank you
Hi @Anonymous ,
You can add an index column in Power Query when you transform the data.
Export the data after sorting this table or visual by index.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , is there a sort column, defined in the model
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |