topic Re: Advanced Filter in Developer

Advanced Filter

danieleperilli — Tue, 19 Jun 2018 16:01:15 GMT

I'm trying to use the AdvancedFilter feature in my visual, but something is not clear to me.

I'm using the following code:

let inValues = [];
let containsValue = '';

let conditions = [];
for (let i = 0; i < inValues.length; i++)
    conditions.push({
        operator: 'Is',
        value: inValues[i]
    });
conditions.push({
    operator: 'Contains', 
    value: containsValue
});
let advancedFilter = new window['powerbi-models'].AdvancedFilter({
    table: TABLE_NAME,
    column: COLUMN_NAME
}, (conditions.length > 1 ? 'Or' : 'And'), conditions);
host.applyJsonFilter(advancedFilter, 'general', 'filter', FilterAction.merge);

After the last line, the filter is applied correctly to the report, but my visual does not receive a filtered data in the subsequently update.

Is it normal?

Re: Advanced Filter

v-viig — Wed, 20 Jun 2018 08:03:05 GMT

Hi @danieleperilli,

This is expected behavior as a filter is applied to other visuals on the same report page.

A custom visual that applies a filter will not get the filtered data.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Advanced Filter

danieleperilli — Wed, 20 Jun 2018 11:10:37 GMT

Thanks @v-viig.

It would useful to have the filtered data as separated node in the dataviews returned in the update. Is it something you could evaluate to insert in the future?

Re: Advanced Filter

v-viig — Fri, 22 Jun 2018 07:41:32 GMT

Could you please describe why your custom slicer should receive a filtered data?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Advanced Filter

danieleperilli — Fri, 22 Jun 2018 07:46:11 GMT

If the slicer receives the filtered data, it can be used to perform advanced search and display results without loading all the rows from the dataset.

Re: Advanced Filter

v-viig — Mon, 25 Jun 2018 08:30:35 GMT

We'll send this idea to PBI CV API team for consideration.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com