Forum Discussion
Solved
Creating a Date Filter in Power BI
Hi I have Date Column and I want to filter for Dates which are less than or equal to certain Date. Currently not able to do that Tried using Page Filter but it does not have that option, is the...
Hi Aloo,
Check the data type of the Date column. If the "is on or before" option is not appearing, the column is likely set to the Text data type instead of Date.
Change the column's data type to Date in Power Query, and the additional date filtering options, including "is on or before", should become available under Advanced Filtering settings.
💡 Helpful? Give a Kudos 👍 — keep the community growing
✅ Solved your issue? Mark as Solution ✔️ — help others find it faster
Best regards,
Rupasree Achari | BI & Fabric Analytics Engineer
