Forum Discussion

Madhan_'s avatar
Madhan_
Frequent Visitor
3 years ago

Handle negative values in power query

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

3 Replies

  • jgeddes's avatar
    jgeddes
    Icon for Super User rankSuper User
    3 years ago

    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_'s avatar
      Madhan_
      Frequent Visitor
      3 years ago

      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?

  • jgeddes's avatar
    jgeddes
    Icon for Super User rankSuper User
    3 years ago

    Click where it says column profiling based on top 1000 rows