Forum Discussion
Sort txt data in Power BI
Hi guys,
I have a txt file with numbers of fuel transactions. The structure of file is in a mess.
Anyone has a easier way to sort out these in Power BI?
Thanks
Joyce
Joycelu819
Power bi is not that kind of tool for something like auto cleansing or sorting. You may use other method to sort csv file before import into power bi to create reports.Found a few methods with my research using Bing.
Sorting A CSV File In Excel | ACTIVEWorks Endurance Answers (activenetwork.com)
Use PowerShell to Sort CSV Files in Order | Scripting Blog (microsoft.com)
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
Joycelu819 , you need to give example of what you need. You can do a lot in power query.
If this is related to sorting /display. You can create a sort column and use that
How to Create Sort Column and Solve Related Errors: https://youtu.be/KK1zu4MBb-c
Hi thanks for your quick response. I feel the link is not quite relevant to my question.
What I am trying to do is structure the messy data from txt file. Just try to organise data like csv format.
Joyce
Joycelu819
Power bi is not that kind of tool for something like auto cleansing or sorting. You may use other method to sort csv file before import into power bi to create reports.Found a few methods with my research using Bing.
Sorting A CSV File In Excel | ACTIVEWorks Endurance Answers (activenetwork.com)
Use PowerShell to Sort CSV Files in Order | Scripting Blog (microsoft.com)
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
