I have an Excel 2010 Pro pivot table that uses a Power Pivot view sourced to a SQL Server 2012 SQL view.  This view contains multiple date fields, and when I attempt to use the 'Value Filter' on one of these, the data is not filtering.  The data type in the SQL view is a date.

After attempting to set a Value Filter, and seeing that the filtering didn't work, when I go back to the Value Filter criteria (in my case, I used 'Greater Than' option), the date value that I plugged in to filter has been replaced with a numeric value.

Any help is greatly appreciated.

Hi,

I had that same issue in the past.

You need to either change your DATE fields into DATETIME ones or (safer way) create a view that performs this conversion then feed your Excel from it.

 

• Marked as answer by captkirk35 10 hours 37 minutes ago

Casting the date fields as Datetime data types in the SQL view, and then using Label Filters instead of Value Filters appears to resolve the issue.

Thanks

• Marked as answer by Charlie LiaoMicrosoft contingent staff, Moderator 6 hours 2 minutes ago