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
newpbiuser01
Helper V
Helper V

Power Query Automatically Filtering Out Null Values

Hello,

 

I am running into an issue while filtering out specific values from a column in Power Query. After I filter out the said specific values, and create my reports, if a Null value is added in that filtered column, that row gets filtered out as well. 


As an example, if I have the following data and I filter out the Name column to exclude "DEF":

NameCountYear
DEF502023
HIJ782022
ABC452020
GHI102024

 

Table.SelectRows(#"Changed Type", each ([Name] <> "DEF"))

 

I get the following result when I try to visual in Power BI:

newpbiuser01_0-1698251916284.png

Now, if I update my data to include a null value in the Name column, refresh the data, and still have "DEF" filtered out from my name column, I see the null row in the Power Query, however, when I push close and apply in Power Query, the null row gets filtered out automatically. 

newpbiuser01_1-1698251998425.png

newpbiuser01_2-1698252076794.png

Would anyone know why the row where the Name = null get filtered out even though I have clearly defined the filter to exclude just the value "DEF" from the Name column :

Table.SelectRows(#"Changed Type", each ([Name] <> "DEF"))

 

I'd appreciate any insight on why this is happening and why nulls are treated differently. 

Thank you!

1 REPLY 1
ray_aramburo
Super User
Super User

Check on the data view if the value is there as a null or as a blank. If it exists there, then the issue is on the visual and you might need to do some steps to show blank values. 





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





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.