Filter not working in Query editor, any help

[acerNZ]

Hi Experts

Objective is to filter one of the coloumns by specific string and rest of the modeling is based on the associated data. 

In the data model, for that specific column, I am happily able to filter the string, but when click on transform data, where I can actually put some code to ensure real time report, when I click on filter, I do not see my specific data, what could be the issue 

As part of trouble shooting:

I deleted the data and loaded it again 

My data source is right and yes every time I can see my relevant data in the drop down filter but I cannot when I look for same in the transform data (Query Editor). Please advise.

[Anonymous]

Hi @acerNZ ,

Does your data contains more than 1000 rows?

If yes, then you can filter that using Advanced Editor.

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

[acerNZ]

@Anonymous Thank you for response, Yes they are more 10,000 rows and Please can you point me to links or way to filter the row for a particular test? can I put in SQL commands in advanced editor? 

[Anonymous]

Hi @acerNZ ,

To use Advanced Editor for filtering, Apply Filter on the required column and then in the right in the Applied Steps section click on Filtered Rows step as below-

And then open Advanced Editor where you can filter your desired data, here is how(Highlighted is the column at whch you want the filter)-

Please mark my post as Soulution if it helps you.

[acerNZ]

@Anonymous  Based on some youtube, I could get the DAX filtter ( add table) and was able to put a filter in the Data view (Modelling), however I am not seeing this table in "Query Editor" when I load the tables in transform. 

[Anonymous · Accepted solution]

@acerNZ ,

You wont be able to see calculated columns/tables in Query Editor.

[acerNZ]

@Anonymous I got same answer, I changed my plans a bit to do filter in the last after massaging the data, where I can.

[HotChilli]

Are we talking about the dropdown that appears when you click on the caret in the column header?

Does it say 'List may be incomplete'-----  Load More  ?

[acerNZ]

Hi @HotChilli 

Yes, you are right.. When I ensure, I load all, still I do not find the element I am searching.