Forum Discussion
Solved
Filter does not applied in power bi query
I have a table called InventTrans, and it contains a large amount of data. I applied a filter in Power Query on the InventDate column to include only records on or after 1/1/2025. However, when I cli...
Hi amal_01
Just a quick reminder based on earlier discussion shared by MFelix if you're still seeing all records load from the InventTrans table despite applying a date filter in Power Query, please ensure the filter step is applied before any other steps that might override it or bring in the full dataset again (like a Changed Type step or re-applied source).
Also, please double-check that:
- The InventDate column is in Date format (not Text).
- The filter is applied early in the query steps, ideally right after the source step.
If the issue still persists reach out to us we are happy to help!
Looking forward for your response..
Hi amal_01 ,
This may depend on a lot of things but I would do a couple of checks, I assume you have already done some of this but just double checking,
- Data type is correct before doing the filter in this case is date
- Be sure the format of thedate you are using in the filter is correct based on your local settings of PBI file
- Number of rows are the same before and after the filter
- Usually I use the Count rows on the Transform bar
- After load do a sorting of the date column to see what is the minimum and maximum value
Without any data and example is difficult to understand what may be happening