topic Apply JSON Filter to own custom visual in Custom Visuals Development Discussion

Apply JSON Filter to own custom visual

lucmax — Thu, 28 Nov 2019 15:21:03 GMT

Hey,

I'm trying to build a new version of our custom visual because I saw other custom visuals (apparently) applying json filters to themself. How can I achive this behaviour and apply a json filter (advanced filter api) to the visual itself which created the filter?

regards,

lucmax

Re: Apply JSON Filter to own custom visual

lucmax — Fri, 29 Nov 2019 07:52:46 GMT

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!

Re: Apply JSON Filter to own custom visual

Charlene — Tue, 19 Jul 2022 08:45:14 GMT

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?

Re: Apply JSON Filter to own custom visual

lucmax — Tue, 19 Jul 2022 08:54:53 GMT

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.