When using Custom Table type filter that is connected to a Sharepoint list, the IsDefault setting fails.

The list contains a specific column for the default setting. I've tried with these data types:
 - Yes/No (which translates to 1/0)
 - Number (tested with 1/0 and -1/0)
 - Text ("True"/"False")

The error appears in the filter as red text: "An unexpected error occurred. Error 30140. Additional details have been logged for your administrator."

I checked server events and found this:
"An unexpected error occurred.  Error 30140.
Exception details:
System.InvalidCastException: Specified cast is not valid.
   at Microsoft.PerformancePoint.Scorecards.Server.PmServer.GetFilterDisplayData(RepositoryLocation filterLocation, ParameterDefinition parameterDefinition, List`1 selections, Boolean useSavedUserSelections, Boolean selectionsOnly, WebPartContext webPartContext)"

Seems like PPS can't create a boolean from the value.

• Edited by antruo Wednesday, March 26, 2014 8:32 AM