Forum Discussion
Apply JSON Filter to own custom visual
With help of a fellow forum member I got it to work the way I want. You need to do the following to have your visual filter itself AND others visuals:
capabilities.json (general)
"properties": { "filter": { "type": { "filter": true } }, "selfFilter": { "type": { "filter": { "selfFilter": true } } } }ApplyJsonFilter call(s)
this._visualHost.applyJsonFilter( filterList, "general", "selfFilter", powerbi.FilterAction.merge ); this._visualHost.applyJsonFilter( filterList, "general", "filter", powerbi.FilterAction.merge );Hope this helps someone else!
With help of a fellow forum member I got it to work the way I want. You need to do the following to have your visual filter itself AND others visuals:
capabilities.json (general)
"properties": {
"filter": {
"type": {
"filter": true
}
},
"selfFilter": {
"type": {
"filter": {
"selfFilter": true
}
}
}
}
ApplyJsonFilter call(s)
this._visualHost.applyJsonFilter(
filterList,
"general",
"selfFilter",
powerbi.FilterAction.merge
);
this._visualHost.applyJsonFilter(
filterList,
"general",
"filter",
powerbi.FilterAction.merge
);
Hope this helps someone else!
Hi, I'm also looking for a way to filter my cutom visual and not just the other visuals.
This query seems to be the closest I can find to what I'm lookng for.
I have the capabilities setup as mentioned, but not sure how and where the applyJSONFilter call is implemented.
Can someone assist me with the steps in order to implement this or direct me to an example as to how this is done?
Hi Charlene,
we are calling the applyJsonFilter in our visual.ts code when the user clicks our filter button. The filter list contains the filters we want to apply in a format like this:
{ $schema: "http://powerbi.com/product/schema#basic", ...new BasicFilter( { table: tableName column: columnName, }, "In", values ), }Maybe this helps.
