Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
TatianaGuihur
Helper I
Helper I

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 only a filter. I really want to delete them of my table.

 

Thanks in advance for helping me,

1 ACCEPTED SOLUTION

Hi @TatianaGuihur ,

 

Set the filter with Power Query. (Transform data)

PQ_NumberFilter.png

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.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


View solution in original post

5 REPLIES 5
amitchandak
Super User
Super User

In data transformation or edit query under Data View. Go and filter you data.

 

Refer :https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data

kentyler
Solution Sage
Solution Sage

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

 





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


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

 

How can I do that? 

 

 

Hi @TatianaGuihur ,

 

Set the filter with Power Query. (Transform data)

PQ_NumberFilter.png

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.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


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

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors