Forum Discussion
Filter Power Query Editor
Hi everyone,
I have data from Jira connected with Power BI. Since there were many null values, I wanted to filter those in the Editor. But after applying the filter, I stille see those null values. So, why doesn't it work? Is it because of the real time connection, so that values keep being loaded?
9 Replies
Maybe it's interpreting your null as text "null"? If you share the code generated for that step, we should be able to tell if this is the case.
Try unchecking (null) from the corner dropdown of the column.
Hi AlexisOlson ,
I think that's the case, though the data type is Date/Time. I duplicated the column and changed it to the data type Date. That did worked. I also discovered there were more columns with null values, and in those columns, the type was indeed Text. So, by changing the data type, it was resolved. Although, it isn't intuitive... Especially with the example I showed you, since that wasn't Text in the first place, but already a Date/Time type.
The code generated for that step is as follows:
= Source{[Name="SLA Cycles",Signature="table"]}[Data]
The code for filtering rows looks like this:
Table.SelectRows(#"Changed Type", each ([SLA] <> null))If it were interpreting null as text, it would look like this:
Table.SelectRows(#"Changed Type", each ([SLA] <> "null"))The key is to make sure it looks like the first one.
