Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Add a feature to filter out non-date values in date columns

This is one of the most frustrating errors in Power BI to troubleshoot: [DataFormat.Error] We couldn't parse the input provided as a Date value. If you set a column as a date, or even specify the locale, you will have non-date values, but you can't filter them out. You have to trick Power BI by removing exact, specific one-off values. It doesn't make sense. If we know a value isn't a date value, then why can't we filter it out on a date column? Could be as simple as right click > Remove non-date values, or Date Filters > Is not > a date value
Status: New
Comments
fbcideas_migusr
New Member
Status changed to: New