Issues Locating and Sorting Imported Data

[DGID]

Hello

This is my first post here so apologies in advance if my terms are not accurate. I am new to Power BI and have started going through the challenges listed on the Enterprise DNA website. Please see the link below for the challenge and the original data that I imported

https://forum.enterprisedna.co/t/power-bi-challenge-1-executive-sales-report/7705

I am having issues with my Sales table | Order Number in that it is not displaying all of the order numbers in the report tab or the data tab. However in PowerQuery I am able to see all the data that was imported correctly so I believe that it is an issue with the transformation? The column cannot be changed to a number because there is alpha characters in the data. 

I feel like that the answer to my issue is similar if not the same as this post.
https://community.powerbi.com/t5/Desktop/Number-sorting-in-text-format/td-p/237256

Since it it sorting and only displaying the first 1000 rows I think I need to create a new column that separates the order ID and sorts it by the new numbers. 

However I again I am very new and do not fully understand the DAX expression provided.

Any assistance would be appreciated, thank you.

Image of how it displays in the report/data tab:

Image of how it displays in the power query editor.

[HotChilli · Accepted solution]

I have done a brief investigation.  The data in Power Query appears sorted but it isn't really, it's probably in the same order as the source system it came from.

----

The order of data in the data view of powerbi doesn't affect visualisations - any sorting or filtering done there is purely there to allow investigating data.

----

You're on the right track with this "I think I need to create a new column that separates the order ID and sorts it by the new numbers".  There are functions available (in the interface) in Power Query and powerbi front end to allow you to do this.  Since you're beginning to learn about powerbi, I'm not going to tell you.  You can research solutions using the verbs that you use in the sentence I quoted.  If you are totally stuck I can offer more hints but it's all out there (in the powerbi documentation and on the web)

Have a look at the How-to-guides->PowerBi reports   in here

https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-create 

[DGID]

Thank you, I was able to figure out where I needed to go after refining my searches.

[HotChilli]

What question are you asking? Do you think you have lost data between 'Close and Apply' in Power Query and loading the data to powerbi front end or do you have a problem sorting data in a visualisation?

[DGID]

It is a problem sorting the order number in the data tab and in a matrix visualization on the report tab. Instead of being able to see the data sequentially by order number, I see the first image which I believe is sorted alphabetically because it is in text format.