Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I followed the steps on https://github.com/Microsoft/powerbi-visuals-sampleslicer However the columns I want to filter is a Measure not Grouping.
I came across IFilterMeasureTarget https://microsoft.github.io/powerbi-models/interfaces/models.ifiltermeasuretarget.html Tried the following
callbacks.getAdvancedFilterColumnTarget = (): IFilterMeasureTarget=> { let valueCol: DataViewValueColumn= this.dataView.categorical.values[0]; let target: IFilterMeasureTarget = { table: valueCol.source.queryName.substr(0,valueCol.source.queryName.indexOf('.')), measure: valueCol.source.queryName, }; return target; };
But its not working
We'd recommend to try to use BasicFilter instead of AdvancedFilter.
const basicFilter: models.IBasicFilter = { target: { table: "Products", column: "Version" }, operator: "In", values: [ 1, 2, 3, 4 ] };
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
target: { table: "Products", column: "Version" },
What should be there for the table and column key for the measure columns ?
We'd recommend to take a look at this code to figure out how to populate table and column name.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
I want to user
IFilterMeasureTarget not IFilterColumnTarget because I want to filter the measure not the category. How do i get the measure and table values. Approach I am following is below but its not working
let target: IFilterMeasureTarget = { table: valueCol.source.queryName.substr(0,valueCol.source.queryName.indexOf('.')), measure: valueCol.source.queryName, };
What is the correct approach to get the
table and measure value
I'll check it out and get back.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
It seems you can use column target instead of measure.
Have you tried such solution?
const min: number = 100; const max: number = 101; if (!this.dataView) { return; } const source = this.dataView.categorical.values[0].source; let conditions: IAdvancedFilterCondition[] = []; if (min) { conditions.push({ operator: "GreaterThan", value: min }); } if (max) { conditions.push({ operator: "LessThan", value: max }); } const query: string[] = /\((\w+).(\w+)\)/.exec(source.queryName); let target: IFilterColumnTarget = { table: query[1], column: query[2], }; let filter: IAdvancedFilter = new window['powerbi-models'].AdvancedFilter(target, "And", conditions); this.host.applyJsonFilter(filter, "general", "filter", FilterAction.merge);
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.