Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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-evelk's avatar
    v-evelk
    Microsoft 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]