cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
datavis Member
Member

Delete rows if blank field

I created two columns related to another data table. I need to delete rows with blanks. I go to query editor and I do not see the columns I created so I can filter out the rows with blanks in the new columns. How can I delete or filter out the rows with blans in those fields?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Delete rows if blank field

Hi @datavis

If you want to filter out blank row in report view, you can set "show item when the value is not blank" in Visual Filter container.

3.png

 

If you want to change the data model with no blank value from column related from other tables.

You could use the formula to create a new table.

table = FILTER(ALL(Sheet2),[Column]<>BLANK())

4.png

 

Best Regards

Maggie

6 REPLIES 6
Super User
Super User

Re: Delete rows if blank field

Did you created the column using DAX ? if yes then you cannot see it in query editor. You can filter the records in query editor so that it doesn;t bring those blank rows to data model, let me know if need further assistance.

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





datavis Member
Member

Re: Delete rows if blank field

Thank you,

 

I clicked Modeling/New Column then named the column and used RELATED(Dept[Department]). So how do I filter it if I can't see the column in the data when I go to Query Editor? Sorry I am new to analytics and to Power BI.

 

 

 

Super User
Super User

Re: Delete rows if blank field

In that case you can drop this field on page level filter and choose "is not blank", to understand various filters, read this article






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





rajendran Super Contributor
Super Contributor

Re: Delete rows if blank field

Just to mention - Power BI cant delete any record, and you may aware of this. Basically, you wanted to filter the blank records.

As @parry2k said, please check where you have created the new columns  , is it done in DAX or in Power Query.

 

If its in DAX- you may need to use ISBLANK() function to filter the records.

 

 

Thanks

Raj

Community Support Team
Community Support Team

Re: Delete rows if blank field

Hi @datavis

If you want to filter out blank row in report view, you can set "show item when the value is not blank" in Visual Filter container.

3.png

 

If you want to change the data model with no blank value from column related from other tables.

You could use the formula to create a new table.

table = FILTER(ALL(Sheet2),[Column]<>BLANK())

4.png

 

Best Regards

Maggie

datavis Member
Member

Re: Delete rows if blank field

Yes! Thank you very helpful!

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 316 members 3,344 guests
Please welcome our newest community members: