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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Remove rows that have a null value in a specific column?

I have a column "Process Step" with qualitative data, but there are many "null" values that prevent me from pivoting the column. I get errors I can't pivot cause of NA values or blank

 

I do NOT want to keep rows with nulls. I want to remove these rows entirely.

 

How can I edit the query and removet hese rows where null exists in a specific column? 

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@Anonymous 

I think you can add a step in the PQ which is filtering that column





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

Proud to be a Super User!




View solution in original post

4 REPLIES 4
ryan_mayu
Super User
Super User

@Anonymous 

I think you can add a step in the PQ which is filtering that column





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

Proud to be a Super User!




Anonymous
Not applicable


@ryan_mayu wrote:

@ryan_mayu

I think you can add a step in the PQ which is filtering that column


You can add a step to filter the column, but doing so doesn't appear to let me pivot still. I get "DataFormat.Error: Invalid cell value '#N/A'." when I try to pivot. 

 

@Anonymous 

could you please provide the sample data and the expected output?





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

Proud to be a Super User!




Anonymous
Not applicable

Filtering it did work actually. I was doing something wrong. Thanks!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.