Filter Power Query Editor

[Anonymous]

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?

[Anonymous]

Hi @Anonymous ,

Ok, thanks for your feedback!😀

Could you please Accept a helpful one as the solution to help the other members find it more quickly.More people will benefit from it.

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @Anonymous ,

• If the Time column is DateTime type, (notice the type icon):

• If the Time column is Text type:

• If Time column is Any type:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi @Anonymous ,

It was solved when I filtered twice all the null and blank values or when I filtered once and then sort rows ascending or descending... 

So, I think this is just a bug for this particular data file. 

[AlexisOlson]

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.

[Anonymous]

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]

[AlexisOlson]

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.

[Anonymous]

Ah okay, the code is as follows:

= Table.SelectRows(#"Reordered Columns", each ([SLA Cycle Breach Time] <> null))

So, the first one, hence it doesn't see it as text, and the filter isn't working. 

[AlexisOlson]

Hmm. I don't know what the issue is then unless it's just a cached view you are seeing. If you click Refresh Preview and the filter still doesn't work, then I don't know what's going on.

[Anonymous]

Thanks for the tip and your help @AlexisOlson . It didn't work unfortunately. So at this moment, the solution for me is just duplicate the column and change data type from Date/Time to Date.