Handle negative values in power query

[Madhan_]

I don't understand how this works. Below I have attached the images of the same dataset from the Power Query window and Data Window. In the data window, the Column unit price is showing a negative value; in the power query window, I can't see any negative value. I need things such as 

1.I want to get rid of this negative value.

2. i want a column where the price units should not be less than 0 like 0.01

3. most important I should not lose any rows.

Please help to resolve the issue. 

Thanks

[jgeddes]

Click where it says column profiling based on top 1000 rows

[jgeddes]

I noticed that in the data window view your dataset is almost 542000 rows while in the Power Query view it is only showing the top 1000 rows. If you expand the Power Query view to include all rows does your missing negative value show up?

[Madhan_]

I clicked load more values in the right click menu on price unit column. But still it shows only 1000 values maximum and says limit of 1000 values reached. so how do i expand more than that?