Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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
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
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?
Could you please describe why your custom slicer should receive a filtered data?
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
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.
We'll send this idea to PBI CV API team for consideration.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |