Forum Discussion
Filter not working in Query editor, any help
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!
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?
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 ?
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.
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.
