Forum Discussion

pankajsonkul's avatar
pankajsonkul
Helper I
9 years ago

Set custom filter values as 'blank' or null

Hi, How to set value as blank to custom filter. Following code which will create custom filter for blank value as null but it throws following error  "values.0 is invalid. Not meeting type c...
Need Help
pankajsonkul's avatar
pankajsonkul
Helper I
9 years ago

Thanks for reply,
It will throws same error
Following date filter,in which we have allready some date filter and 'Blank' filter whenever we read this filter values in code it will display below output
$schema:"http://powerbi.com/product/schema#basic"
operator:"NotIn"
target:"object"
column:"Date"
table:"DateRange"
__proto__:"object"
values:Array(1)
0:null
length:1

now whenever we add new value in this custom filter it will throws exception for null value.

Existing filter screen shot 

This existing filter values in this filter we want push new filter value like'Feb 2017' it will push but due to null value  it will throws error.Actually in filter pane it will display as '(Blank)' but in code this value is null.

So how we can handle this null value.