topic Apply JSON Filter not working in Custom Visuals Development Discussion

Apply JSON Filter not working

Anonymous — Wed, 18 Sep 2019 09:18:35 GMT

So I have been following the steps that were outlined here https://microsoft.github.io/PowerBI-visuals/docs/concepts/filter-api/#basic-filter-api

I created a basic filter:

let target: IFilterColumnTarget = {

table: "DataTable",

column: "Category1"

};

let values = [ 1, 2, 3 ];

let filter: BasicFilter = new BasicFilter(target, "NotIn",

this.visualHost.applyJsonFilter(filter, "general", "filter", FilterAction.merge);

in my capabilities, I have added as specified:

"general": {

"displayName": "General",

"displayNameKey": "formattingGeneral",

"properties": {

"filter": {

"type": {

"filter": true

}

I know that my json filter is being applied. But for some reason the dataview that I receive doesn't change at all. Can anyone help?

Re: Apply JSON Filter not working

jppp — Thu, 19 Sep 2019 08:02:00 GMT

Hi @Anonymous ,

this.visualHost.applyJsonFilter() pushes the filter back to Power BI so that all other visuals on the page are filtered by the content of the filter. It doesn't filter the data that the visual is getting; slicer are using the same technique.

-JP

Re: Apply JSON Filter not working

Anonymous — Fri, 20 Sep 2019 00:08:55 GMT

Yep, I've realised now thanks.

It turns out the answer was simply to use

visualhost.applyJsonFilter(advancedFilter, "general", "selfFilter", FilterAction.merge);

instead of

visualhost.applyJsonFilter(advancedFilter, "general", "Filter", FilterAction.merge);

This will filter the visual and not all the other visuals.

Re: Apply JSON Filter not working

Anonymous — Fri, 20 Sep 2019 15:36:26 GMT

Hello.

Can you please share your current repository project?

Right now I'm facing an issue with FilterAction.merge

host.applyJsonFilter(models.AdvancedFilter, "general", "selfFilter", FilterAction.merge);

Cannot find name 'FilterAction'.

Thank You.

@Anonymous wrote:
Yep, I've realised now thanks.

It turns out the answer was simply to use

visualhost.applyJsonFilter(advancedFilter, "general", "selfFilter", FilterAction.merge);

instead of

visualhost.applyJsonFilter(advancedFilter, "general", "Filter", FilterAction.merge);

This will filter the visual and not all the other visuals.

Re: Apply JSON Filter not working

Anonymous — Sun, 22 Sep 2019 23:39:36 GMT

You need to add this to the top to import FilterAction

import FilterAction = powerbi.FilterAction;

Re: Apply JSON Filter not working

lucmax — Thu, 28 Nov 2019 15:52:13 GMT

Hey @Anonymous ,

I'm trying to achieve exactly the behaviour and have my custom visual filter itself. I can't get your solution to work, did you do any other changes regarding for example the capabilities?

regards,

lucmax

Re: Apply JSON Filter not working

Anonymous — Fri, 29 Nov 2019 04:04:36 GMT

Hey lucmax,

So you need to add selfFilter to your general capabilities too. Like this. So instead of filter, replace with selfFilter. There is no documentation for this, so it was a lot of trial and error.

"selfFilter": {

"type": {

"filter": {

"selfFilter": true

}

Re: Apply JSON Filter not working

lucmax — Fri, 29 Nov 2019 07:47:11 GMT

Thank you @Anonymous! That helped a lot. I tried changing them, but didn't do it with the double "selfFilter" key.