Forum Discussion
Anonymous
6 years agoNot applicable
TopN Filter always orders by first column
let tableName = 'table';
let column = 'column3'
let filterTarget: models.IFilterColumnTarget = {
table: tableName,
column: column
};
let orderByTarget: any = {
table: tableName,
column: column
}
let advancedFilter = new models.TopNFilter(
filterTarget,
this.direction,
10,
orderByTarget
);
this.visualHost.applyJsonFilter(advancedFilter, "general", "selfFilter", FilterAction.merge);
So I have this filter that I created like above and I'm applying this filter to my dataset for a custom visual. I am also ordering the filter by the column that I am filtering (my table has 5 columns), so that the filtered column is sorted.
However, for some reason, it is always ordering by column 1 and not ordering the column that I want it to order (column 3). This means that my column 3 will never get ordered. Can anyone help regarding this? Thanks!
1 Reply
- v-evelkMicrosoft Employee
Hello,
I've requested clarification from an appropriate specialist.
As soon as I get a response, I will provide it here.
Kind Regards,
Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
[email protected]