TopN Filter always orders by first column

Anonymous — Mon, 30 Sep 2019 08:14:08 GMT

        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!

Re: TopN Filter always orders by first column

v-evelk — Tue, 01 Oct 2019 13:17:52 GMT

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
pbicvsupport@microsoft.com

topic Re: TopN Filter always orders by first column in Custom Visuals Development Discussion

TopN Filter always orders by first column

Re: TopN Filter always orders by first column