topic Re: Custom Slicer Loses Value When Toggling Visibility in Developer

Custom Slicer Loses Value When Toggling Visibility

cboneill0099 — Wed, 13 May 2020 20:05:27 GMT

I have a custom slicer I wrote that filters dates. It's pretty basic, you just give it a date field and it lets you filter the report down to a single date. The issue I'm having with it is if I select a date, the report filters down correctly. If I then hide the visual it loses the selection and the filter is gone.

I'm having trouble finding documentation on what's happening behind the scenes when it's hidden. Can anyone give me some insights into what's going on and if there is some type of special handling for this secenario?

Thanks

Re: Custom Slicer Loses Value When Toggling Visibility

v-lid-msft — Thu, 14 May 2020 06:41:53 GMT

Hi cboneill0099 ,

Seems it act like a visual interaction instead of filter, please try to added the Advanced Filter API based on this similar thread: https://community.powerbi.com/t5/Developer/Custom-Slicer-Selection-Issue/td-p/371992

Best regards,

Re: Custom Slicer Loses Value When Toggling Visibility

cboneill0099 — Thu, 14 May 2020 12:02:38 GMT

Thank you. I'll give that a shot.

Re: Custom Slicer Loses Value When Toggling Visibility

cboneill0099 — Wed, 20 May 2020 23:13:09 GMT

I attempted to use the filtering API and it solved half of my problem. Now, when I hide the visual the filter does not go away, but when I make the visual visable again, the filter gets lost. Is there something I should be doing to persist the filter behind the scenes and reload it when making the visual visable again?

Here is my code in the update method:

let filterTarget: IFilterColumnTarget = { table: categories.source.queryName.substr(0, categories.source.queryName.indexOf('.')), column: categories.source.displayName }; const basicFilter: IBasicFilter = { $schema: "http://powerbi.com/product/schema#basic", // target: { // table:"Date", // column:"CalendarYear" // }, target: filterTarget, operator: "In", values: [dateSelectionValue], //[2019], filterType: FilterType.Basic } this.visualHost.applyJsonFilter(basicFilter, "general", "filter", FilterAction.merge);

This is what I added to the capabilities file:

"general": { "displayName": "General", "displayNameKey": "formattingGeneral", "properties": { "filter": { "type": { "filter": true } }, "selfFilter": { "type": { "filter": { "selfFilter": true } } } } }

Thank you

Re: Custom Slicer Loses Value When Toggling Visibility

cboneill0099 — Thu, 21 May 2020 13:50:16 GMT

There was an error in my code causing the filter to get lost. The above solution worked for me.

Thank you.