Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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":
Name | Count | Year |
DEF | 50 | 2023 |
HIJ | 78 | 2022 |
ABC | 45 | 2020 |
GHI | 10 | 2024 |
Table.SelectRows(#"Changed Type", each ([Name] <> "DEF"))
I get the following result when I try to visual in Power BI:
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.
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!
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.
Proud to be a Super User!
User | Count |
---|---|
120 | |
69 | |
68 | |
57 | |
50 |
User | Count |
---|---|
166 | |
82 | |
68 | |
65 | |
54 |