Forum Discussion

TatianaGuihur's avatar
TatianaGuihur
Helper I
6 years ago
Solved

Remove negatives

Hello all,  Its my first time wrinting in this forum.    I would like to delete all the lines that have a negative number in my column "IdComm".  I dont want to filter greater than 0, because is ...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi TatianaGuihur ,

     

    Set the filter with Power Query. (Transform data)

    Regards,

    Marcus

    Dortmund - Germany
    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support.

kentyler's avatar
kentyler
Solution Sage
6 years ago

If you want to really delete records from your table, you may have to delete them in your datasource.

You could use Power Query to delete them, but they would only be deleted from the data you loaded into power bi.

 

 

I'm a personal Power Bi Trainer I learn something every time I answer a question

 

TatianaGuihur's avatar
TatianaGuihur
Helper I
6 years ago

yes, I only want to delete them in my power bi report. Not in the BD source.

 

How can I do that? 

 

 

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi TatianaGuihur ,

     

    Set the filter with Power Query. (Transform data)

    Regards,

    Marcus

    Dortmund - Germany
    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support.

    • TatianaGuihur's avatar
      TatianaGuihur
      Helper I
      6 years ago

      Thank you so much for helping you three people. I did what mwegener  said.  Is working now. I understand better.

       

    • Ravi501566's avatar
      Ravi501566
      New Member
      7 months ago

      i could see a number of null i customer_id ,do i filter them out too.

      i am a learning power bi for 3 days now , it would be huge help if u replied.